I will give it a moon shot, you made that look easy! Thank You!

--
Tuna Pete


"JBeaucaire" wrote:

A1 = Speed to match
B1 = racer's speed

C1 = Result formula:

=IF(AND(B1=ROUND(A1-A1*1.25%,2), B1=ROUND(A1+A1*1.25%,2)), "Good", "Busted")

Does that do it for you?
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Pete" wrote:

I need to come up with a formula that will result in Good or Busted
The racers speed must be within 1.25% (+ or -) of the speed entered into
the equation and produce "Good"

If the Speed exceeds or falls below 1.25% of the speed entered -The answer
will be "Busted"

Example- entered 105.25 mph must be between 103.93 and 106.57 to be
"Good" If the calculation is out side of those parimeters = Busted
--
Tuna Pete