# Formula

Posted by Ed on February 07, 2002 9:17 AM

I'm sure this is simple to many but I have not been
able to figure it out.

Need a Formula for this:

IF(E19&LT;4,4.4)
IF(E19>3&LT;7,4.85)
IF(E19>6&LT;13,5.55)
IF(E19>12&LT;20,6.70)
IF(E19>19&LT;40*.33)
If(E19>39&LT;60*.29)
IF(E19>59&LT;100*.27)
Thanks,
Ed

Posted by Brian on February 07, 2002 1:17 PM

What exactly are you trying to do Ed? You have a couple of holes in your logic. What outcome for 3.5, which is greater than 3 and less than 4? And what exactly are the *'s meant to represent in this case?

Posted by Ed on February 07, 2002 2:42 PM

Brian:
The numbers will all be whole numbers.
* is multiply by the .26 or whatever the given amount is.
I am making an order form where the supplier charges a different amount for each set of weights. e.g. up to 3 lbs = \$4.40, 4-6 lbs \$4.85
Any help would be appriciated.
Ed

Posted by Brian on February 08, 2002 2:04 PM

This should do it ED,if I understand you correctly.

=IF(E19&LT;=3,4.4,IF(E19&LT;=6,4.85,IF(E19&LT;=13,5.55,IF(E19&LT;=20,6.7,IF(E19&LT;=40,E19*0.33,IF(E19&LT;=60,E19*0.29,IF(E19&LT;=100,E19*0.27,"Above 100")))))))

Unfortunately with nested IF's you can only go as far as 7 so if you want to make any more allowances than you have there you are stuck.

Posted by Ed on February 08, 2002 6:46 PM

Thanks for the help.
Ed