Formula to link a few cell to Calculate

[Sky]

Hi,

Could anyone help me.
Table of different country freight cost.
A standard template to calculate the actual total cost.
If I entered 100 and Origin Italy it will auto take 100*0.65*2.1=136.5 as
formula
136.5 is higher than 40 so it is OK.
If the ans is 39 it should use 40 as min.
The Fuel and security also convert according as show below

Table
Airport Dest Currency Origin Min -45 +45 +100 +500
ABC SIN USD USA 35 0.36 0.31 0.27 0.26
Rate 1.45
Fuel USD 0.55/kg
Security USD 0.17/kg

Airport Dest Currency Origin Min -45 +45 +100 +500
EFG SIN EUR Italy 40 0.55 0.66 0.65 0.64
Rate 2.1
Fuel EUR 0.45/kg
Security EUR 0.20/kg

Airport Dest Currency Origin Min -45 +45 +100 +500
HIJ SIN AUD Aust 40 0.55 0.40 0.39 0.38
Rate 1.1
Fuel AUD 0.35/kg
Security AUD 0.25/kg

Template
Origin Italy
Airport Description Rate Comment
Eur Port to Port 136.5 (100*0.65*2.1)
SIN Agency Fee 45
SIN Delivery Charge 30
SIN DO Fee 60
SIN Permit Fee 60
SIN Wharfage 60
EUR Fuel 115.5 (0.55*100*2.1)
EUR Security 35.7 ( 0.17*100*2.1)
SIN Total 542.70

 

[Squeaky]

Hi Sky,

=if(100*0.65*2.1<40,40,100*0.65*2.1) will work for the first example. You
can modify it for the others.

If you think of the commas in the formula as IF-THEN-OTHERWISE statements
you get:

IF 100 x .65 x 2.1 is less than 40, THEN 40, OTHERWISE 100 x .65 x 2.1

You can set any part to reference another cell. If you put 100 in cell a1
you can make the formula:

=if(A1*0.65*2.1<40,40,A1*0.65*2.1) This will give the same answer.

Then you can change the value of cell A1 to whatever you wish. Same with the
0.65 part.

Hope this helps.

Squeaky