Can IF function produce a blank cell?

I'm using the IF function to create a column of data which will be
charted. If the IF criterion isn't satisfied, I'd like it to output a
blank cell, rather than a zero or some other number, so it won't be
charted. Is there any way to do this? Thanks,

Andrew

Hi

You could use a space or #N/A in your formula:

=IF(A2<0," ",A2)
=IF(A2<0,"#N/A",A2)

They both seem to work for me.

Andy

<agbiggs@hotmail.com> wrote in message
news:1141058052.551758.200120@j33g2000cwa.googlegroups.com...
> I'm using the IF function to create a column of data which will be
> charted. If the IF criterion isn't satisfied, I'd like it to output a
> blank cell, rather than a zero or some other number, so it won't be
> charted. Is there any way to do this? Thanks,
>
> Andrew
>

Hi Andrew,

=IF(YourCondition,YourValue,=NA())

--
Kind regards,

Niek Otten

<agbiggs@hotmail.com> wrote in message
news:1141058052.551758.200120@j33g2000cwa.googlegroups.com...
> I'm using the IF function to create a column of data which will be
> charted. If the IF criterion isn't satisfied, I'd like it to output a
> blank cell, rather than a zero or some other number, so it won't be
> charted. Is there any way to do this? Thanks,
>
> Andrew
>

Hi

=IF(Condition,YourFormula,"")

Arvi Laanemets



<agbiggs@hotmail.com> wrote in message
news:1141058052.551758.200120@j33g2000cwa.googlegroups.com...
> I'm using the IF function to create a column of data which will be
> charted. If the IF criterion isn't satisfied, I'd like it to output a
> blank cell, rather than a zero or some other number, so it won't be
> charted. Is there any way to do this? Thanks,
>
> Andrew
>

People must have had a heavy weekend.
Niek's =IF(YourCondition,YourValue,=NA()) should read
=IF(YourCondition,YourValue,NA())
and Andy's =IF(A2<0,"#N/A",A2) should be =IF(A2<0,#N/A,A2)

I thought I was the only one prone to typos!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

<agbiggs@hotmail.com> wrote in message
news:1141058052.551758.200120@j33g2000cwa.googlegroups.com...
> I'm using the IF function to create a column of data which will be
> charted. If the IF criterion isn't satisfied, I'd like it to output a
> blank cell, rather than a zero or some other number, so it won't be
> charted. Is there any way to do this? Thanks,
>
> Andrew
>

Also be advised that =IF(A2<0,"",A2) in B1 will give a value of FALSE if you
then use =ISBLANK(B1). This is because a formula is not a blank even when
the cell looks blank.

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

<agbiggs@hotmail.com> wrote in message
news:1141058052.551758.200120@j33g2000cwa.googlegroups.com...
> I'm using the IF function to create a column of data which will be
> charted. If the IF criterion isn't satisfied, I'd like it to output a
> blank cell, rather than a zero or some other number, so it won't be
> charted. Is there any way to do this? Thanks,
>
> Andrew
>

Opps!!!!!
That should be
> and Andy's =IF(A2<0,"#N/A",A2) should be =IF(A2<0,NA(),A2)



--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:%23$BLD%237OGHA.3144@TK2MSFTNGP11.phx.gbl...
> People must have had a heavy weekend.
> Niek's =IF(YourCondition,YourValue,=NA()) should read
> =IF(YourCondition,YourValue,NA())
> and Andy's =IF(A2<0,"#N/A",A2) should be =IF(A2<0,#N/A,A2)
>
> I thought I was the only one prone to typos!
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> <agbiggs@hotmail.com> wrote in message
> news:1141058052.551758.200120@j33g2000cwa.googlegroups.com...
>> I'm using the IF function to create a column of data which will be
>> charted. If the IF criterion isn't satisfied, I'd like it to output a
>> blank cell, rather than a zero or some other number, so it won't be
>> charted. Is there any way to do this? Thanks,
>>
>> Andrew
>>
>
>

Thanks, Bernard.

I "always" test a formula.
The very few occasions that I don't usually get me on the right track again!

--
Kind regards,

Niek Otten

"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:%23$BLD%237OGHA.3144@TK2MSFTNGP11.phx.gbl...
> People must have had a heavy weekend.
> Niek's =IF(YourCondition,YourValue,=NA()) should read
> =IF(YourCondition,YourValue,NA())
> and Andy's =IF(A2<0,"#N/A",A2) should be =IF(A2<0,#N/A,A2)
>
> I thought I was the only one prone to typos!
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> <agbiggs@hotmail.com> wrote in message
> news:1141058052.551758.200120@j33g2000cwa.googlegroups.com...
>> I'm using the IF function to create a column of data which will be
>> charted. If the IF criterion isn't satisfied, I'd like it to output a
>> blank cell, rather than a zero or some other number, so it won't be
>> charted. Is there any way to do this? Thanks,
>>
>> Andrew
>>
>
>

Super -- thanks for all the help! Problem solved.

Andrew