Forum Discussion
_Milena_
Jun 06, 2019Copper Contributor
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
_Milena_ , perhaps
=MAX(10,MAX(B19,B20*1000)*0.01)
16 Replies
- TwifooSilver ContributorYour desired result seems to be the MAXimum of the 3 values representing each argument of this formula:
=MAX(10,B19*.01,B20*10) - SergeiBaklanDiamond Contributor
_Milena_ , perhaps
=MAX(10,MAX(B19,B20*1000)*0.01)
- _Milena_Copper Contributor
- SergeiBaklanDiamond Contributor
_Milena_ , you are welcome