On Wed, 20 Jul 2005 15:22:25 +0800, melo <melo@gmail.com> wrote in
microsoft.public.excel:

>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.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"