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.