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

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

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

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