| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
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(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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lose relative connection in formula on sort | Excel Worksheet Functions | |||
| Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
| When using & and a date-formatted cell in a formula I lose the for | Excel Worksheet Functions | |||
| how do i clear data in excel and not lose the formula | Excel Worksheet Functions | |||
| Formula Set Up Needed | Charts and Charting in Excel | |||
Linear Mode
