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
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
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.
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!
Numbers currency Formatting on Apple Mac
