View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default Force Excel To Treat A Cell As Blank

If a cell contains a formula, then the cell is not blank. Even if the
formula returns nothing, the presence of the formula makes the cell non-blank.

Perhaps if you explained what you are trying to do, an alternative could be
suggested.

HTH,
Elkar


"MDW" wrote:

I want to have the false part of an IF statement to return a...null?...value
I guess. I want Excel to treat the cell as if it were blank.

Right now, this is the function I have:

=IF(M4<"",IF(ISERROR(YEAR(N4)),M4,N4),"")

It's the

,""

part that I want to replace with whatever will make the cell appear empty.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!