Home

IF formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-722674%22%20slang%3D%22en-US%22%3EIF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722674%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Team%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20come%20up%20with%20a%20formula%20that%20will%20put%20the%20data%20from%20column%20A%20in%20a%20Column%20C%20if%20there%20is%20data%20in%20column%20A%20-%20I%20have%20that%20part%20as%20IF(A1%26lt%3B%26gt%3B%22%22%2CA1)%3C%2FP%3E%3CP%3EHowever%2C%20if%20column%20A%20is%20blank%20I%20want%20the%20data%20from%20Column%20B%20to%20be%20placed%20into%20Column%20C%20and%20am%20having%20trouble%20with%20the%20complete%20formula.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20great!%20TIA.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-722674%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722677%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722677%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367287%22%20target%3D%22_blank%22%3E%40pfmje%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DIF(ISBLANK(A1)%2CB1%2CA1)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722681%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722681%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367287%22%20target%3D%22_blank%22%3E%40pfmje%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20formula%20out%20in%20cell%20C1%3A%3C%2FP%3E%3CP%3E%3DIF(ISBLANK(A1)%2CB1%2CA1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20if%20you%20wanted%20to%20finish%20the%20formula%20the%20way%20you%20started%2C%20it%20would%20be%3A%3C%2FP%3E%3CP%3E%3D%3CSPAN%3EIF(A1%26lt%3B%26gt%3B%22%22%2CA1%2CB1)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3C%2FP%3E%3CP%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722699%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722699%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B-%20Thanks!%20That%20worked.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722713%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722713%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367287%22%20target%3D%22_blank%22%3E%40pfmje%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20welcome.%20As%20variant%2C%20if%20both%20A1%20and%20B1%20are%20numbers%20or%20blanks%20only%20that%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DISBLANK(A1)*B1%2BA1%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
pfmje
New Contributor

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

@pfmje 

It could be

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

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

@Sergei Baklan - Thanks! That worked. 

@pfmje 

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