iasiddiqui Wrote:
Hello,

I need to write an IF statement. Basically, I want cell A21 = D4
*-if-* a value is present in it. If D4 is blank, then A21 should = D7.
How would I set this up?

Hi iasiddiqui,

Try this,

=IF(D40,D4,D7)

oldchippy :)

Sorry try this instead

=IF(D4=ISBLANK(D4),D4,D7)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=571803