Hi Everyone ,

I am thinking a way to set up a template for other to use.
Could anyone give some comment or suggestion to help me to calculate the
cost? or
May I know is there a formula to help me on my template? or
Is there others ways for me to improve or amend this template? or


I had a file consist of a few table and a template.
The table consist of a few Airport.
The template is to calculate the total cost

For example
Is there a way, If I entered 100 and Origin Italy it will auto take
100*0.65*2.1=136.5 and if enter 30 it will use and shown the min 40.
But on the other hand it also need to link with the fuel and security to
convert as shown 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
SIN Port to Port 136.5 (100*0.65*2.1)
SIN Fuel 115.5 (0.55*100*2.1)
SIN Security 35.7 ( 0.17*100*2.1)
SIN Total 287.7