 • 511K Members
• 5,405 Online
• 608K Conversations

# IF formula help

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.

4 Replies

# Re: IF formula help

It could be

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

# Re: IF formula help

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

# Re: IF formula help

@Sergei Baklan - Thanks! That worked.

# Re: IF formula help

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

`=ISBLANK(A1)*B1+A1`

Related Conversations
Need help with concatenate formula
Dave Cunningham in Excel on
2 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies