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?

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

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

=IF(E19<=3,4.4,IF(E19<=6,4.85,IF(E19<=13,5.55,IF(E19<=20,6.7,IF(E19<=40,E19*0.33,IF(E19<=60,E19*0.29,IF(E19<=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.