Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for calculator Table
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for calculator Table
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for calculator Table
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for calculator Table
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for calculator Table
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Need Formula for Calculator | Excel Worksheet Functions | |||
Calculator Table | Excel Discussion (Misc queries) | |||
Applying percentage calculator to table | New Users to Excel | |||
mortgage calculator formula | Excel Worksheet Functions | |||
formula calculator for PC vs. mac | Excel Worksheet Functions |