You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Numbers currency Formatting on Apple Mac

Why do some numbers in a Numbers spread sheet refuse to format as currency? In both cases they are the result of a calulation using the IF function.


What do I need to do to successfully format these calculation results as currency?


This formats currency successfully:

IF(BT41>0,IF(BL41>0,BK41,""),"")


This does not:

IF(BT38>0,IF(BL38>0,BK38,""),"")

Posted on Nov 3, 2021 3:32 PM

Reply
4 replies

Nov 3, 2021 3:39 PM in response to BillfromPyrmont

If the result of your IF statement is not not a number, it will not format as currency.


Example 1:

=IF(A2, "1", 2)

If A2 is true then the result is the text "1". It is not a numeric value, it is text and will not take a currency format.

If A2 is false then the result is 2, which is a numeric value and will format as currency


Example 2:

=IF(A2, B2, 2)

If cell B2 contains a text "number", it will not take on a currency format

Numbers currency Formatting on Apple Mac

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