I realise this is a very basic question but I am at a loss to work out the undoubtedly simple solution.
I have a table with two columns. 1 with prices in Pounds 1 with prices in Euros. Not all the cells in each column are filled in depending on whether I paid in pounds or euros. I want a way to fill in the blank cells with either the equivalent amount in euros or pounds.
What I have tried so far will change the entire column to euros or the entire column to sterling but not the individual cells if you see what I mean, here is a link to a test document to see if some kind soul can put me out of my misery. Test
Welcome to Coda, and the community! And since you were clever enough to find the community AND provide an example doc, you are no longer dumb, nor is this a dumb question.
Some questions to clarify the requirement first:
Do I understand the doc correctly, in that you want to regularly revalue to the latest rates, and keep a track of past revaluations?
Or do you simply want to revalue to the latest exchange rate? If so, do you want to keep the old rates, or are you satisfied with just capturing the latest exchange rate?
Depending on the answers to the above, your doc will look very, very different.
buttons work wonders in these scenarios
the filter formula may look impressive, but is maybe less so if you look at some hidden columns I added with a few steps showing you how I got here.
So I thought I could just have a fixed figure that I input somewhere eg 0.83 for euro and 1.20 for GBP
Then each cell could use those figures to calculate the amounts.
So in answer to your question just revalue to the latest exchange rate and I don’t need to keep track of historical changes. The simplest of simple things… thanks for being kind.
