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