something like =if(D3="",DISPLAY NULL VALUE,D5-D3)

what can i put in there to make it a null value

"Todd" wrote:

I know you can chart blank cells as spaces by clicking it in the
options...this is a little different.

The cell it is charting as an if function in it to display a blank cell.
example:

=if(D3="","",D5-D3)

So when D3 is blank it should display in cell D6 a blank. But when it charts
it, it charts it as a zero. I want it to chart it as a gap.

I tried =if(D3="",NA(),D5-D3), This way i get a "#N/A" error in my cell,
which i can hide through conditional formating. but when i click displaydata
labelsvalues in chart options it displays "#N/A" instead of a gap.

I need to somehow display a gap.

Please help