Hi There,

I have three categories of cost per unit depending on volume.

0-5 KG then cost is 10 per unit
6-15 KG then cost is 5 per unit
16 - 60 KG then cost is 2 per unit

I need to create an IF formula (I assume this is best) that captures: IF weight is lower than 5 KG or lower then the sheet should calculate X*10. IF weight is between 6 to 15 KG then sheet should calculate X*5, IF weight is above 16 KG sheet should calculate X*2.

I just got stuck here when I have three different categories of unit cost per weight category. Can anyone assist?

Thank you!

//M