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

=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

Try the following:-

=IF(ISERR(D1),E1,D1)


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

stefi and Gary,

Thanks! I'll give your suggestions a try and see what comes out. I
appreciate your willigness to help!


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

stefi and Gary,

Thanks! I gave your suggestions a try and was successful. I
appreciate your willigness to help!


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