Prev: Vlookup from different sheets
Next: Using a Text Cell to Reference a Worksheet Name
From: Rene B. Rene on 31 May 2010 07:01
Within an IF function, I would like to have the cell left blank given a
certain logical result. The purpose is to have a result, that does not show
up as a zero in a chart.
Using "" in the function will make the chart function perceive the value of
the cell as a zero instead of a completely blank cell (i.e. as after having
hit Delete, while being in the cell).
How is that done???
Thanks

From: Roger Govier on 31 May 2010 07:13
Hi Rene

Use NA() for your false result rather than ""
=IF(A1>0,25,NA())

--
Regards
Roger Govier

Rene B. wrote:
> Within an IF function, I would like to have the cell left blank given a
> certain logical result. The purpose is to have a result, that does not show
> up as a zero in a chart.
> Using "" in the function will make the chart function perceive the value of
> the cell as a zero instead of a completely blank cell (i.e. as after having
> hit Delete, while being in the cell).
> How is that done???
> Thanks
>
From: Anand on 1 Jun 2010 10:06
As the =SERIES() won't read N/A error the chart won't produce results
for them...

On May 31, 4:13 pm, Roger Govier <ro...(a)technology4nospamu.co.uk>
wrote:
> Hi Rene
>
> Use NA() for your false result rather than ""
> =IF(A1>0,25,NA())
>
> --
> Regards
> Roger Govier
>
> Rene B. wrote:
> > Within an IF function, I would like to have the cell left blank given a
> > certain logical result. The purpose is to have a result, that does not show
> > up as a zero in a chart.
> > Using "" in the function will make the chart function perceive the value of
> > the cell as a zero instead of a completely blank cell (i.e. as after having
> > hit Delete, while being in the cell).
> > How is that done???
> > Thanks

 | 
Pages: 1
Prev: Vlookup from different sheets
Next: Using a Text Cell to Reference a Worksheet Name