# Convert a list of receipts in one currency using an exchange rate from a signle cell

1. ## Convert a list of receipts in one currency using an exchange rate from a signle cell

Hi
I have receipts in UK pounds that are listed in Column F rows 6 to 25.
I have the exchange rate to Euros in Cell C4.
How do I simply convert all the currencies rather than doing each cell individually (F6/C4; F7/C4; F8/C4 etc)?
Help much appreciated.
David

2. ## Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

Hi,

Do you mean that you just want the total of F6:F25 converted to euros? Which could be implied by your mention of not wanting each cell individually

Or perhaps you want in F6 and then copied down
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

=F6/C\$4
And drag the formula down

4. ## Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

Apologies for not being clear.
What I need is each receipt converted into Euros.
i.e. the value in F6 in £ shown in G6 as Euro; the value in F7 in £ in G7 in Euro etc.
I don't need the total of all column F.

5. ## Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

Hi to both of you. Thank you. That's exactly what I needed.
Your help is much appreciated by this 70 year old!

6. ## Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

Originally Posted by Theale
Hi to both of you. Thank you. That's exactly what I needed.
Your help is much appreciated by this 70 year old!
Glad to have helped and thanks for the rep....I'm only two years behind you.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1