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 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 sheetsNext: Using a Text Cell to Reference a Worksheet Name