win or lose formula needed
That was much better. I was searching everywhere for the data cell LOL
--
Thank You . .. All you guys have been a life savers tonight - Tuna Pete
"T. Valko" wrote:
Ooops!
I left out a comparison cell....
A2 = racer speed = 105.25
B2 = target speed
=IF(AND(A2=ROUND(B2*0.9875,2),A2<=ROUND(B2*1.0125 ,2)),"Good","Busted")
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
One way...
A2 = 105.25
=IF(AND(A2=ROUND(A2*0.9875,2),A2<=ROUND(A2*1.0125 ,2)),"Good","Busted")
--
Biff
Microsoft Excel MVP
"Pete" wrote in message
...
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
.
|