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