Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

South African Currency Code

How do I insert the South African currency code into a cell formatted to convert a specific $ amount into rand? IE: CURRENCY("$45"'"ZAR")


I'm trying to make a cell that will keep an updated conversion of $45 in South African Rands.

iMac 24″, macOS 12.6

Posted on Sep 15, 2022 5:19 AM

Reply
Question marked as Best answer

Ok I finally got it!


Posted on Sep 15, 2022 11:29 PM

6 replies

Sep 15, 2022 8:46 PM in response to WawaReno

WawaReno wrote:

What I need though is for the one cell to convert $45 to ZAR.


Then, following the general syntax I posted above, you can do something like this:




=45*CURRENCY("USD","ZAR",0)



In general, though, it is not always best practice to "hard-code" values into a formula like that, because it makes it harder to change things or figure out what you did when you come back to the document some time later. That is why I suggested having the currency symbols and dollar amount outside the formula.


SG




South African Currency Code

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.