I want to create a chart which will display a zero value on the data label
where there is in fact a zero value, and show N/A on the data label where it
didn't apply. The formula I am using in the spreadsheet uses a nested formula
to make this determination:
=IF(AND(B22+C220,C220),B22/C22,NA())
Presently, it works but displays the #N/A on the chart where I would prefer
it simply displayed as N/A. Can I do this with a custom format on the data
label??

Thanks so much! I don't know how you all do it but your amazing!


--
If you can read this, thank a Teacher...
If your reading it in English, thank a Veteran!