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

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