| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
if than statement has too many variable
Hello I'm pretty much a novice at using Excel but made a formula a couple years ago to calculate freight. There are 2 basic scenarios, if the weight falls between a certain brackets it gets a set price or it gets multiplied by a percentage. I think the max number of if than statements is seven... correct? My excel file was corrupted about 3 months back and I have been unsuccessful in recreating it. I'm open to using a more appropriate formula or fixing the current one. Either way I appreciate the help. =IF(E4<=50,28,IF(E4<=305,42,IF(E4<=393,E4*0.1373,I F(E4<=500,54.05,IF(E4<=712,E4*0.1081,IF(E4<=1000,7 7)))))) Thanks Chris -- repke ------------------------------------------------------------------------ repke's Profile: http://www.excelforum.com/member.php...fo&userid=9890 View this thread: http://www.excelforum.com/showthread...hreadid=537915 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
if than statement has too many variable
Chris,
Your current formula worked fine for me, with the exception that it didn't handle weights greater than 1000. You could change the last IF to something like - if you have a rate for items over 1000..... =IF(E4<=50,28,IF(E4<=305,42,IF(E4<=393,E4*0.1373,I F(E4<=500,54.05,IF(E4<=712,E4*0.1081,IF(E4<=1000,7 7,0.07*E4)))))) HTH, Bernie MS Excel MVP "repke" wrote in message ... Hello I'm pretty much a novice at using Excel but made a formula a couple years ago to calculate freight. There are 2 basic scenarios, if the weight falls between a certain brackets it gets a set price or it gets multiplied by a percentage. I think the max number of if than statements is seven... correct? My excel file was corrupted about 3 months back and I have been unsuccessful in recreating it. I'm open to using a more appropriate formula or fixing the current one. Either way I appreciate the help. =IF(E4<=50,28,IF(E4<=305,42,IF(E4<=393,E4*0.1373,I F(E4<=500,54.05,IF(E4<=712,E4*0.1081,IF(E4<=1000,7 7)))))) Thanks Chris -- repke ------------------------------------------------------------------------ repke's Profile: http://www.excelforum.com/member.php...fo&userid=9890 View this thread: http://www.excelforum.com/showthread...hreadid=537915 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| testing more than one variable in an if statement | Excel Discussion (Misc queries) | |||
| Add 2nd variable to if statement - ifAnd? | Excel Worksheet Functions | |||
Linear Mode
