G
Guest
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.
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.