With your Pounds in A2, and your Pound/$ conversion factor in B2, enter
=ROUND(A2/B2,2) in Col C2. To calculate your $/Pound (If you want to use
exactly the same ratio, which is not always correct), in Col F2 enter =1/B2,
with your $ value in Col E2. In Col G2 enter =ROUND(E2/F2,2)

"Mel Garcia via OfficeKB.com" wrote:

I need anyones help.. I need a formula that converts the Pound to us
dollars and another one that converts us dollars to pound.

Can anyone help me

Mel

--
Message posted via http://www.officekb.com