G Guest Dec 28, 2004 #1 Is there a logic function in EXCEL that will allow me to leave a cell empty when certain conditions are met? Thanks.
Is there a logic function in EXCEL that will allow me to leave a cell empty when certain conditions are met? Thanks.
G Guest Dec 28, 2004 #2 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
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
D Dave Peterson Dec 28, 2004 #3 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)
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)
G Guest Dec 28, 2004 #4 The NA() worked perfectly. Many thanks. 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 Click to expand...
The NA() worked perfectly. Many thanks. 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 Click to expand...
