Convertion

[melo]

i have three column to calulate the expenses,
1. RMB
2. USA
3. HKD

I need to convert either RMB or USA column into HKD amount, here is how
it goes..

A B C D
1 RMB USA HKD
2 100 94 (=HKD/1.06)
100 780 (=USA*7.8)

does any one tell me how to write this formula?

Many thanks
Melo

 

[Bob Phillips]

I would put the RMB/HKD rate in a cell, say M1, and the USA/HKD in M2, and
then use

=ROUND(IF(A3<>"",A3/$M$1,B3*$M$2),2)

 

[Michael Bednarek]

i have three column to calulate the expenses,
1. RMB
2. USA
3. HKD

I need to convert either RMB or USA column into HKD amount, here is how
it goes..

A B C D
1 RMB USA HKD
2 100 94 (=HKD/1.06)
100 780 (=USA*7.8)

does any one tell me how to write this formula?

Try this: enter in D2:
=IF(A2<>0,A2/1.06,B2*7.8)
and copy down.