I need help with building formula for iPhone Numbers to change its output according to currency formatted in cell.
this helps reduce additional columns and number of formulas
iPad mini 6, iPadOS 17
CURRENCYCODE will give you the code for the currency in the cell. If you will have only a few different currencies you can use IFS to do different things based on the code. If you will have more than a few, a lookup table might be required. It is difficult to say much more from the limited information provided.
CAD is the ISO currency code. CA$ is not. Same with USD vs $. Do you need the answer to be how Numbers formats the currencies?
Thanks. That is answer. Until there is a function that sets currency format of data column, I need to check if currency I manually set for data column matches currency part of My Header.
Thanks for useful help. But how to get CURRENCYCODE returns currency format of a cell? My cell shows CA$ but CURRENCYCODE outputs CAD.
how to get iphone Numbers to detect currency format of a cell?
