IsBlank Multiple Outcomes/ Cells

[NjayW]

I use this place a lot and have always found answers here but am stumped with this one!!
Everything is in cell C1
If cell A1 is blank then leave Cell C1 blank
If cell B1 is blank then copy Cell D1 to C1
Been playing around with is blank, or, and etc... But can't seem to get it to work.
All help is appreciated!!!

 

[mvancleave]

Is this what you are looking for (in C1)?

=IF(ISBLANK(A1),"",IF(ISBLANK(B1),D1,""))

 

[NjayW]

Amazing! So simple. The more I thought about it the more complicated I was making it. Thanks mvancleave!!!

 

[mvancleave]

No problem. Glad to help.

 

[Peter_SSs]

If you want less typing, you can also write that as

=IF(A1="","",IF(B1="",D1,""))

 

[mvancleave]

Actually, Peter's solution is more robust. ISBLANK() can return FALSE if the referenced cell contains a formula, even if the formula returns what looks like a "blank" cell. Peter's solution avoids that.