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
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.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
=F6/C$4
And drag the formula down
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
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.
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.Originally Posted by Theale
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks