Thread
:
Formula for calculator Table
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Sky[_2_]
external usenet poster
Posts: 42
Formula for calculator Table
Hi Eduardo,
Sorry still couldn't get it.
Could kindly send me an Excel file to my email
'
"Eduardo" wrote:
Hi,
I assume that you enter 100 in C4 and you want the calculation in D4, I
assume as well that -45 is in F2, 45 in G2, etc and the FX 1.45 is in D3,
change in formula to fit your needs
=IF(IF(C4<45,C4*D3*F2,IF(AND(C4=45,C4<100),C4*G2* D3,IF(AND(C4=100,C4<500),C4*D3*H2,C4*D3*I2)))<E2, E2,IF(C4<45,C4*D3*F2,IF(AND(C4=45,C4<100),C4*G2*D 3,IF(AND(C4=100,C4<500),C4*D3*H2,C4*D3*I2))))
so in D4 enter
"Sky" wrote:
Hi Eduardo,
I enter the 100 next to Port to Port. - 100 mean 100kg
35 is to tell me the min cost.
-45 mean below 45kg and +45 mean above 45kg
Is there a formula to auto run once I enter 100 (100*0.27=27*rate 1.45)=39.15.
39.15 is higher than 35 so it is OK.
If the ans is 34 it should use 35 as min.
"Eduardo" wrote:
Hi,
could you please explain where you enter 100, what is the number 35 under
currency, you have a column -45 and a column minimun, which criteria do you
use to select which column to apply
"Sky" wrote:
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
Reply With Quote
Sky[_2_]
View Public Profile
Find all posts by Sky[_2_]