Forum Discussion

_Milena_'s avatar
_Milena_
Copper Contributor
Jun 06, 2019
Solved

Excel formula help

Hi everybody!

 

Although i have been using Excel every day, the time has come today to realise i know nothing about formulas :)

I'm struggling to make the attached calculator works as follows:

- i need the "sea freight" to get the value either from "weight" or "cubic", whichever is greater, but i need the cubics to be multiplied by 1000 in advance. Then, in order to calculate the cost, it should multiply it by 0.01 

- if the weight is 1000 kg or under and the cubic is 1 or under, the minimum of $10 to apply

 

I have spent hours reading and searching but couldn't find a way to do that.

 

Thanks in advance for your time

 

Milena

 

16 Replies

Resources