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