I am wondering of you would be able to help me with a nested IF function problem I am having. Here is the question: (it's a long one sorry!)
If the freight type is Victor Von Doom Freight then the freight cost is calculated at $4.50 per kilogram of the item weight and a quarter of a cent ($0.0025) per kilometer (distance) if over 1,000km per item ordered (Order Qty).
If the freight type is Otto Octavis Transport then the freight cost is $10 for the first 1.5 kilograms and then $2.50 per kilogram over 1.5kg per item ordered (Order Qty).
**I also must include ROUNDING to 2 decimal places
So basically I have my IF statement as follows:
IF(FreightType="Victor Von Doom Freight", ROUND((4.5*ItemWeight+IF(Distance>1000,0.0025*Distance,"0"))*OrderQty,2), IF(FreightType="Otto Octavius Transport", ROUND((10+IF(ItemWeight>1.5, (ItemWeight-1.5)*2.5,"0"))*OrderQty,2),"0")