Is there a logic function in EXCEL that will allow me to leave a cell empty
when certain conditions are met?

Thanks.

Since the formula needs to be in the cell it can only be pseudo empty

=""

If you want to be able to use it in a chart you can use NA() insytead of ""
otherwise you would need VBA


Regards,

Peo Sjoblom

"Dennis" wrote:

Is there a logic function in EXCEL that will allow me to leave a cell empty
when certain conditions are met?

Thanks.

You can make it look like the cell is empty--but it'll still have a formula in
it:

=if(and(a112,b1=3,c1="hithere"),"","this is not empty)



Dennis wrote:

Is there a logic function in EXCEL that will allow me to leave a cell empty
when certain conditions are met?

Thanks.

--

Dave Peterson

The NA() worked perfectly. Many thanks.

Dennis

"Peo Sjoblom" wrote:

Since the formula needs to be in the cell it can only be pseudo empty

=""

If you want to be able to use it in a chart you can use NA() insytead of ""
otherwise you would need VBA


Regards,

Peo Sjoblom

"Dennis" wrote:

Is there a logic function in EXCEL that will allow me to leave a cell empty
when certain conditions are met?

Thanks.