"I see where I made a mistake that caused the confusion. In my text { "Cell (A1) converted in "&(B3)" }, (A1) obviously should be (A5) "
Initially, you said:
The outcome should look like this:
As presented, and using the conversion rates in effect at about the this screen shot being posted, the the labels in all cells (except for the row number in each of the labels in row 1) correctly describe what appears to be displayed in row 5 of the table.
The screen shot should show the text you want to be displayed in each of the cells, so please enter that text directly into the cells that are currently showing error message or the wrong information.
I am assuming the 1,000 value in A5 is directly entered, and each of the values in cells B5, C5, and D5 are calculated by multiplying the value in A5 by the current exchange rate for the currency identified in row 4 of the same column.
If that is the case, there is no need for the (A1) reference (corrected to (A5) to be different. Each of the three values is a conversion of the amount in column A to the equivalent in the currency named in the label in row 3 of 'this column.
IF the value in each of columns B, C and D is calculated from the value in the colunn to its left, you will need to increment the letter part of A5 for each row, BUT you will also increase the number of calculations to determine the value, and get an incrementally less accurate calculation as you progress to the right.
If you are planning to include more than one row of values to be converted to the same set of currencies, you should drop the cell reference to A5 and place a column reference to A.
Making that single change ("A1" to either "A5" or "column A") in the formula offered in my reply above should pri=ovide the result you need in B1, C1 ans D1.
Regards,
Barry
