Charts

G

GILBERT

Is there way to display "NA" with numbers ?
For example
JAN-55%
FEB-NA
MARCH-0%
APRIL-35%
in the data table the above will be shown and not a 0 for the NA for FEB
 
K

Kevin B

I'm not sure if you're concatenting Month to Value, but if you want an "NA"
when a value is zero you can use an IF to determine the return value.

=IF(A1=0,"N/A",A1)

If cell A1 is a 0 then use N/A, otherwise use the value in A1
 
Top