D
Dennis
Is there a logic function in EXCEL that will allow me to leave a cell empty
when certain conditions are met?
Thanks.
when certain conditions are met?
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
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
=""
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
D
Dave Peterson
You can make it look like the cell is empty--but it'll still have a formula in
it:
=if(and(a1>12,b1=3,c1="hithere"),"","this is not empty)
it:
=if(and(a1>12,b1=3,c1="hithere"),"","this is not empty)
D
Dennis
The NA() worked perfectly. Many thanks.
Dennis
Dennis
Peo Sjoblom said: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