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,""),"")