Convertion

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

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)

--
HTH

Bob Phillips

"melo" <melo@gmail.com> wrote in message
news:%2347WKvPjFHA.1148@TK2MSFTNGP12.phx.gbl...
> 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

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"