IF formula help

[pfmje]

Hi Team, 

I am trying to come up with a formula that will put the data from column A in a Column C if there is data in column A - I have that part as IF(A1<>"",A1)

However, if column A is blank I want the data from Column B to be placed into Column C and am having trouble with the complete formula.  

Any help would be great! TIA.

[#2]

@pfmje 

It could be

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

[#3]

Hello @pfmje,

Try this formula out in cell C1:

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

or if you wanted to finish the formula the way you started, it would be:

=IF(A1<>"",A1,B1)

Hope this helps!

PReagan

[#4]

@Sergei Baklan - Thanks! That worked. 

[#5]

@pfmje 

You are welcome. As variant, if both A1 and B1 are numbers or blanks only that could be

=ISBLANK(A1)*B1+A1