Category condition selection

M

Mike Lewis

It could be done with some Vlookup formulas, here is a
formula that will calculate cost of a weight in cell C24:

=IF(C24<1,3.46,IF(C24<1.5,4.45,IF(C24<2,4.78,IF
(C24<10,9.62,(INT((C24-10)/0.25)*0.86)+9.62))))

Good Luck

Mike
 
M

Mike Lewis

oops - I forgot about partial weights over 10. There
should be another "1". This one works better. It is still
messy though:

=IF(C24<1,3.46,IF(C24<1.5,4.45,IF(C24<2,4.78,IF
(C24<10,9.62,(INT((C24-10)/0.25)+1)*0.86)+9.62)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

End of Statement error 3
Please help with this error message 1
Using median if in VBA. Excel. 3 conditions stop running? 1
Category condition selection 0
Formulas Won't Auto Calc 1
Excel - Wich Function should I use? 1
Selecting a Value from a Range of Values 1
Error Auto Fill Method of Range Class Failed 1

Top