Jun 26 2019 01:11 PM
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.
Jun 26 2019 01:17 PM
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
Jun 26 2019 01:30 PM
You are welcome. As variant, if both A1 and B1 are numbers or blanks only that could be
=ISBLANK(A1)*B1+A1