Hi All,
I wondered if anyone has any ideas for me. I've created a spreadsheet for one of our sales guys to prove how quickly our product will pay for itself. I've included a box where the user enters the current conversion rate of £pounds to $dollars, €uros, ¥en etc. which automatically updates the prices for all the products.
However, I'm looking for a way to it to display the correct currency symbol as well as the correct prices. I've experimented with creating a drop-down list with the relevant countries and it populates the previous cells before the figures with the correct currency symbol (using IF) but this isn't really cutting the mustard as I need to display alternative symbols for about fifteen different currencies.
Would anyone know the best way to go about this? I'd greatly appreciate any hints or suggestions anyone might have to offer!
Thanks,
Angela
Bookmarks