SOLVED

Urgent formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2416040%22%20slang%3D%22en-US%22%3EUrgent%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416040%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20need%20help%20creating%20a%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20i%20enter%20new%20text%20into%20column%20C%20i%20need%20column%20D%20to%20pick%20up%20that%20data%3C%2FP%3E%3CP%3Ebut%20if%20column%20c%20does%20not%20contain%20new%20data%20i%20need%20column%20d%20to%20pick%20up%20data%20from%20column%20B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2416040%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2416122%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416122%22%20slang%3D%22en-US%22%3E%23please%20help%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2416158%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416158%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1071138%22%20target%3D%22_blank%22%3E%40meganpayne156%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20D1%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(C1%3D%22%22%2C%20B1%2C%20C1)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

i need help creating a formula:

 

if i enter new text into column C i need column D to pick up that data

but if column c does not contain new data i need column d to pick up data from column B

4 Replies
#please help
best response confirmed by allyreckerman (Microsoft)
Solution

@meganpayne156 

In D1

=IF(C1="", B1, C1)
Thank you so much! I've just used it now!

@meganpayne156 , glad it helped