Category condition selection

  • Thread starter Thread starter Mike Lewis
  • Start date Start date
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
 
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)))
 
Back
Top