software

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 quot;Ifquot; or the
word quot;Iifquot; 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: www.excelforum.com/member.php...oamp;userid=28808
View this thread: www.excelforum.com/showthread...hreadid=535931=If(IsBlank(D1),E1,D1)

Regards,
Stefi

?reaseman??ezt ?rta:

gt;
gt; I'm trying to make a simple formula, such as
gt;
gt; =If(Is Null(D1),E1,D1)
gt;
gt; But keep getting a #NAME error. Should I be using the word quot;Ifquot; or the
gt; word quot;Iifquot; in my formula? What else can I check for to fix my #NAME
gt; error?
gt;
gt; Thanks in advance to you Excel geniuses!!
gt;
gt;
gt; --
gt; greaseman
gt; ------------------------------------------------------------------------
gt; greaseman's Profile: www.excelforum.com/member.php...oamp;userid=28808
gt; View this thread: www.excelforum.com/showthread...hreadid=535931
gt;
gt;


Try the following:-

=IF(ISERR(D1),E1,D1)--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: www.excelforum.com/member.php...oamp;userid=17084
View this thread: 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: www.excelforum.com/member.php...oamp;userid=28808
View this thread: 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: www.excelforum.com/member.php...oamp;userid=28808
View this thread: www.excelforum.com/showthread...hreadid=535931