Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!
View Course

Help please! IFs and Blank

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at

Help please! IFs and Blank

Postby antoniosunpongco » Sat May 20, 2017 3:10 am

i have 4 Cells, B2, C2, D2 and E2.
Formula will be in B2.
If C2,D2 & E2 are blank, then B2 is Blank
If C2 is Not Blank, then B2 = C2
If C2 & D2 are not Blank, then B2 = D2
If C2, D2 & E2 are not blank, then B2 = E2
But sometimes i get answer only in D2 or E2,
I want B2 to be = to D2 or E2 even if C2 or D2 is also Blank
I hope what i ask is understandable.

Thank you
  • 0

Posts: 1
Joined: May 20, 2017
Reputation: 0
Excel Version: 2013

Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 15 guests