Sure - I have a blank page. So I can put in whatever is required. The only constant at this stage is the starting point of £60,000.Originally Posted by NBVC
Could you explain a little more on the lookup idea? I use vlookup so I would be comfortable using this - just not sure on the starting point.
Well,
My idea is that you enter the values as numbers only, like 60000 starting
in adjacent column you enter the currency, like £...
You would have a table off to the side of currencies and exchange rates
So assuming your first entry is in A2 and in B2 you have a currency of £
and assuming your table is in X2:Y5
Then make an entry in A3 and place corresponding currency in B3
In a new column say C2 enter =A2 (you can format this as £) in C3 you would have a formula like:
=C2-A3*VLOOKUP(B3,$X$2:$Y$5,2,0)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks