Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
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?
