Forum Discussion
Excel formula help
_Milena_ , perhaps
=MAX(10,MAX(B19,B20*1000)*0.01)
Yes, i guess we could devide the weight by 1000, instead of multiplying the cubes by 1000.
The idea is that the calculator should consider 1 cbm = 1000 kg
Regarding the first example, i'm after the following result:
USD 10 / 1.23 = GBP 8.13
Weight 3200 / 1000 = 2.8
Cubics 3.8
So 8.13 x 3.8 = 30.894
If weight is under 1000 AND cubics are under 1.0, then a minimum of GBP 8.13 should be applicable
It was working perfectly untill i decided to mess it up by getting a "0" value in B29, when B25 and B26 are empty... 😄
Again, thanks for your help Sergei and apologies if i haven't make all clear since the beginning
Regards,
Milena
Milena, when I'd suggest to modify a bit your sheet.
First, remove Merging cells for the exchange rate, instead select A2:D2, Ctrl+1 and Center Across Selection.
In A2 just type the number with current exchange rate (1.23), Ctrl+1 and apply custom format as here
With this we may take exchange rate to formula from this cell.
The same for B1 and D1, let keep here only number formatting them with text through custom format. For B2
With this formula in B29 will be
=MAX(MAX(B25/1000,B26)*$B$1,$D$1)/$A$2*(B25<>0)*(B26<>0)Exchange rate and min Sea Freight we take from the cells and not hardcode them within the formula.
Please check in attached file.
Milena, you are welcome, glad to help.