• 408K Members
• 8,520 Online
• 463K Conversations

New Contributor

# 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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies