Apple Intelligence is now available on iPhone, iPad, and 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,""),"")
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
This is true. I've used the "" result to display nothing rather than zeros. However when a number is found it displays as a number, but refuses to format as currency. Is it possible that the contents of BK58 in my second example could contain something that prevents currency formatting even though it is a number > zero?
Thank you for revealing the gold that solves the puzzle of currency formatting. My extensive searching through Numbers documentation did not find it. By using the "VALUE" function I can now force number text string to be a number which can be formatted as currency!
If BK58 (or BK38, whichever it is) is text, the result of the IF statement will be text. If a cell is formatted as text, numeric characters in that cell will be text, not "actual" numbers.
Numbers currency Formatting on Apple Mac
