win or lose formula needed
 

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

win or lose formula needed
 

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

win or lose formula needed
 

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

win or lose formula needed
 

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

win or lose formula needed
 

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

win or lose formula needed
 

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

win or lose formula needed
 

Another fun one:

Just for the heck of it...

A2 = racer speed
B2 = target speed

=IF(A2=MEDIAN(A2,ROUND(B2*1.0125,2),ROUND(B2*0.987 5,2)),"Good","Busted")


--
Biff
Microsoft Excel MVP


"JBeaucaire" wrote in message
...
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

win or lose formula needed
 

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

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




.

win or lose formula needed
 

OVER/UNDER:

=IF(A1<B1,"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

win or lose formula needed
 

Your The Man ! . . . .. check your e-mail, Thanks, Pete
--
Tuna Pete


"JBeaucaire" wrote:

OVER/UNDER:

=IF(A1<B1,"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