November 12th, 2009, 04:43 AM
posted to microsoft.public.excel.misc
|
|
win or lose formula needed
Your The Man ! . . . .. check your e-mail, Thanks, Pete
--
Tuna Pete
"JBeaucaire" wrote:
OVER/UNDER:
=IF(A1B1,"Over","Under")
DIFFERENCE:
=B1-A1
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)
Your feedback is appreciated, click YES if this post helped you.
"Pete" wrote:
That one worked out GREAT! now could A4 tell us if the speed was busted
because was ("over" or "under")
and for a real topper, "could A5 tell us by how much"
That will put a fork in my needs tonight
--
Thank You! Tuna Pete
"JBeaucaire" wrote:
Another fun one:
=IF(ROUND(MAX(A1:B1)-MIN(A1:B1),2) = ROUND(A1*1.25%,2), "Good", "Busted")
--
"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
|