Hi,

Could anyone help me.
I had a table on some rate as per below shown.
If I entered 100 it will auto take 100*0.27*1.45=39.15 as formula

Airport Dest Country Currency Min -45 +45 +100 +500
ABC SIN USD 35 0.36 0.31 0.27 0.26

Airport Description Rate Comment
USA Port to Port 39.15 (100*0.27=27*rate 1.45)
SIN Delivery Charge 30
SIN Agency Fee 45
SIN DO Fee 60
SIN TH Charge 40
SIN Permit Fee 60
SIN Wharfage 60
Total 334.15