New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Help please! IFs and Blank

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

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

antoniosunpongco
Rookie
 
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 57 guests

cron