=If(IsBlank(D1),E1,D1)

Regards,
Stefi

€žgreaseman€� ezt Ã*rta:


I'm trying to make a simple formula, such as

=If(Is Null(D1),E1,D1)

But keep getting a #NAME error. Should I be using the word "If" or the
word "Iif" in my formula? What else can I check for to fix my #NAME
error?

Thanks in advance to you Excel geniuses!!


--
greaseman
------------------------------------------------------------------------
greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808
View this thread: http://www.excelforum.com/showthread...hreadid=535931