ExcelBanter - Return blank for true "if" statement when charting, not 0

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Return blank for true "if" statement when charting, not 0 (https://www.excelbanter.com/charts-charting-excel/95288-return-blank-true-if-statement-when-charting-not-0-a.html)

Jay F

Return blank for true "if" statement when charting, not 0

Andy Pope

Return blank for true "if" statement when charting, not 0

Hi,

In your formula use NA() instead of zero or ""
Something like,

=IF(test , NA() , False )

Cheers
Andy

Jay F wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 09:30 PM.