CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
user2846737
user2846737

Reputation: 211

How to combine two columns into one base on conditions in excel

I am new to Excel. This might be really basic...Please help

Column1 Column2
A         B
C         D
E
F
G

The rule is if Column1 and Column2 are both not blank, get the values of Column2. so the new columns will be:

Column3
B
D
E
F
G

Thanks!

Upvotes: 0

Views: 2203

Answers (1)

Pankaj Jaju
Pankaj Jaju

Reputation: 5471

In resultant column, you can use the following formula

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

Upvotes: 2

Related Questions