| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formula with multiple conditions and answers.
Biff...Here are all the variables. We are trying to figure
a fee for the total in G5. The answer will be in M5. Thanks for your help... If G5< or = to 2500 then answer is 77.48, if G5 is between 2,500.01 - 100,000.00 then answer is 84.13 if G5 is between 100,000.01 - 500,000.00 then answer is 101.89 if G5 is between 500,000.01 - 5,000,000.00 then answer is 146.67 if G5 is greater than or equal to 5,000,000.01 answer is 399.00 "T. Valko" wrote: If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000 then answer is 84.13 Etc... The logic of your 2nd IF is wrong. It should be: =2500.01 How many "Etc...'s" are there? Post *all* of the conditions. Biff "Headacheaday" wrote in message ... Help, I am trying to write a conditional formula with many conditions and I keep getting errors, or just true or false. I need specific answers in the cells.. I.E. 77.48, 84.13.. etc... If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000 then answer is 84.13 Etc... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formula with multiple conditions and answers.
Try this:
=LOOKUP(G5,{0,0.01,2500.01,100000.01,500000.01,500 0000.01},{"",77.48,84.13,101.89,146.67,399}) If G5 is empty or = 0 the formula returns a blank. Biff "Headacheaday" wrote in message ... Biff...Here are all the variables. We are trying to figure a fee for the total in G5. The answer will be in M5. Thanks for your help... If G5< or = to 2500 then answer is 77.48, if G5 is between 2,500.01 - 100,000.00 then answer is 84.13 if G5 is between 100,000.01 - 500,000.00 then answer is 101.89 if G5 is between 500,000.01 - 5,000,000.00 then answer is 146.67 if G5 is greater than or equal to 5,000,000.01 answer is 399.00 "T. Valko" wrote: If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000 then answer is 84.13 Etc... The logic of your 2nd IF is wrong. It should be: =2500.01 How many "Etc...'s" are there? Post *all* of the conditions. Biff "Headacheaday" wrote in message ... Help, I am trying to write a conditional formula with many conditions and I keep getting errors, or just true or false. I need specific answers in the cells.. I.E. 77.48, 84.13.. etc... If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000 then answer is 84.13 Etc... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formula with multiple conditions and answers.
=IF(G5<=2500,77.48,IF(G5<=100000,84.13,IF(G5<=5000 00,101.89,IF(G5<=5000000,146.67,399))))
-- David Biddulph "Headacheaday" wrote in message ... Biff...Here are all the variables. We are trying to figure a fee for the total in G5. The answer will be in M5. Thanks for your help... If G5< or = to 2500 then answer is 77.48, if G5 is between 2,500.01 - 100,000.00 then answer is 84.13 if G5 is between 100,000.01 - 500,000.00 then answer is 101.89 if G5 is between 500,000.01 - 5,000,000.00 then answer is 146.67 if G5 is greater than or equal to 5,000,000.01 answer is 399.00 "T. Valko" wrote: If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000 then answer is 84.13 Etc... The logic of your 2nd IF is wrong. It should be: =2500.01 How many "Etc...'s" are there? Post *all* of the conditions. Biff "Headacheaday" wrote in message ... Help, I am trying to write a conditional formula with many conditions and I keep getting errors, or just true or false. I need specific answers in the cells.. I.E. 77.48, 84.13.. etc... If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000 then answer is 84.13 Etc... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formula with multiple conditions and answers.
Thanks Biff and David, they both worked, you guys are the bomb.
"David Biddulph" wrote: =IF(G5<=2500,77.48,IF(G5<=100000,84.13,IF(G5<=5000 00,101.89,IF(G5<=5000000,146.67,399)))) -- David Biddulph "Headacheaday" wrote in message ... Biff...Here are all the variables. We are trying to figure a fee for the total in G5. The answer will be in M5. Thanks for your help... If G5< or = to 2500 then answer is 77.48, if G5 is between 2,500.01 - 100,000.00 then answer is 84.13 if G5 is between 100,000.01 - 500,000.00 then answer is 101.89 if G5 is between 500,000.01 - 5,000,000.00 then answer is 146.67 if G5 is greater than or equal to 5,000,000.01 answer is 399.00 "T. Valko" wrote: If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000 then answer is 84.13 Etc... The logic of your 2nd IF is wrong. It should be: =2500.01 How many "Etc...'s" are there? Post *all* of the conditions. Biff "Headacheaday" wrote in message ... Help, I am trying to write a conditional formula with many conditions and I keep getting errors, or just true or false. I need specific answers in the cells.. I.E. 77.48, 84.13.. etc... If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000 then answer is 84.13 Etc... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
