Shipping price calc

**boopathiraja** · 10-15-2014, 07:07 AM

May be this

Formula:

=IF(A1>1,4,IF(A1>0.1,3,1.5))

**Allgermanparts** · 10-15-2014, 08:34 AM

Originally Posted by boopathiraja

May be this

Formula:

=IF(A1>1,4,IF(A1>0.1,3,1.5))

OK so I'm trying this method and I may be doing it wrong but I think it's almost but not quite right. Please correct me if I'm wrong. (E1) is the weight so assume weight is less than 100g and cost is £1.50 then =IF(E1>0.1,1.5) Is that correct? if so I'll move to the next level