Need help with and "IF" statement - ASAP
 

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?


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

Need help with and "IF" statement - ASAP
 

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

Need help with and "IF" statement - ASAP
 

=IF(D4<"",A21,D7)

"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?


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

Need help with and "IF" statement - ASAP
 

...oops ...

=IF(D4<"",D4,D7)

"Toppers" wrote:

=IF(D4<"",A21,D7)

"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?


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

Need help with and "IF" statement - ASAP
 

no, neither is working


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

Need help with and "IF" statement - ASAP
 

let me clarify:

A21 = D4 only if D4 contains a value. If D4 is blank, then A21 = D7.


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

Need help with and "IF" statement - ASAP
 

thank you very much, that worked!!!


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