Currency and formulas and cell references.
How do I get the currency symbol to pull through in a cell reference??
I have a sheet which contains multiple cost lines in multiple currencies in the Estimate column. Like so:
If I want to reference that column elsewhere in the sheet e.g. =Estimate@row/2 how can I get the currency sign pulled through?
If I define the currency in the Estimate column (or cell) using the Currency dropdown- I get no currency symbol in the referencing cell, just the value (40, 60)
If I apply 'No Currency' from the dropdown to the Estimate column and manually input £40 or $60 - I get no currency symbol in the referencing cell, just the value (40,60)
The only way to get the symbol is manually select the appropriate Currency from the dropdown in every individual cell right the way across the sheet where I am expecting £ $. This is going to be c.5 or 6 cells! If there's user error and we have £ in one and $ in another, well....you can imagine the consequences.
Am I doing something wrong?
Is there a smarter way to deal with it where put maybe a currency dropdown in another field and then use a formula to convert the requisite cells into £/$ depending on the value in the dropdown.
Hope someone can help.
Help Article Resources
Check out the Formula Handbook template!