Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ex Rate
hello,
i am doing following formula in C1 but facing error ! Col_A Col_B Col_C Amount Ex.Rate US$ SGD 100 10.00 USD 1,000 (=A1*B1) this type is okay USD 100 00.00 USD 100 ( in USD case i just want bring same amount in C1 100 as of A2) I copied C1~C100 formula Hope you could understand it. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ex Rate
How do you distinguish between the varioous currencies? Maybe change your
formula to read =IF(OR(B2="",B2=0),A2,A2*B2) -- Hth Kassie Kasselman "Tufail" wrote: hello, i am doing following formula in C1 but facing error ! Col_A Col_B Col_C Amount Ex.Rate US$ SGD 100 10.00 USD 1,000 (=A1*B1) this type is okay USD 100 00.00 USD 100 ( in USD case i just want bring same amount in C1 100 as of A2) I copied C1~C100 formula Hope you could understand it. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ex Rate
For line 2, the exchange rate is 1.00.
Column C could be written as C4: =A4*if(b4=0,1,b4) "Tufail" wrote in message ... hello, i am doing following formula in C1 but facing error ! Col_A Col_B Col_C Amount Ex.Rate US$ SGD 100 10.00 USD 1,000 (=A1*B1) this type is okay USD 100 00.00 USD 100 ( in USD case i just want bring same amount in C1 100 as of A2) I copied C1~C100 formula Hope you could understand it. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ex Rate
You are quite correct that the exchange rate should be 1, which would of
course mean that the OP's formula would be correct. However, having the 0 is what requires the IF! ;-) -- Hth Kassie Kasselman "Stephen Rasey" wrote: For line 2, the exchange rate is 1.00. Column C could be written as C4: =A4*if(b4=0,1,b4) "Tufail" wrote in message ... hello, i am doing following formula in C1 but facing error ! Col_A Col_B Col_C Amount Ex.Rate US$ SGD 100 10.00 USD 1,000 (=A1*B1) this type is okay USD 100 00.00 USD 100 ( in USD case i just want bring same amount in C1 100 as of A2) I copied C1~C100 formula Hope you could understand it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to calculate billable rate using base rate and percentage | Excel Worksheet Functions | |||
Calculating a daily rate when the rate could be fixed or variable | New Users to Excel | |||
Prime rate/Liber rate into sheet automatically? | Excel Discussion (Misc queries) | |||
Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions |