IF formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-3106405%22%20slang%3D%22en-US%22%3EIF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3106405%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIm%20trying%20to%20make%20cells%20S2%2C%20T2%20%26amp%3B%20U2%20equal%20the%20same%20as%20cells%20M2%2C%20N2%20%26amp%3B%20O2%20%3CSTRONG%3Eif%3C%2FSTRONG%3E%20there%20is%20a%20number%20in%20%3CSTRONG%3Eeither%3C%2FSTRONG%3E%20P2%20or%20Q2%20-%20Could%20someone%20please%20tell%20me%20the%20formula%3F%20Ive%20got%20as%20far%20as%20making%20it%20work%20if%20there%20is%20something%20in%20P2%20by%20using%26nbsp%3B%3DIF(P2%26gt%3B%3D1%2CM2)%20but%20cant%20work%20our%20how%20to%20add%20in%20the%20%3CSTRONG%3EOR%3C%2FSTRONG%3E%20Q2%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22omclean_0-1643822672569.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344678i602F2D0C7D0F7736%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22omclean_0-1643822672569.png%22%20alt%3D%22omclean_0-1643822672569.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3106405%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3107484%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3107484%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1295070%22%20target%3D%22_blank%22%3E%40omclean%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20S2%3AU2.%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula.%20If%20you%20are%20not%20using%20Office%202021%20or%20Microsoft%20365%2C%20confirm%20the%20formula%20with%20Ctrl%2BShift%2BEnter.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(OR(P2%26lt%3B%26gt%3B%22%22%2CQ2%26lt%3B%26gt%3B%22%22)%2CM2%3AO2%2C%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi All

 

Im trying to make cells S2, T2 & U2 equal the same as cells M2, N2 & O2 if there is a number in either P2 or Q2 - Could someone please tell me the formula? Ive got as far as making it work if there is something in P2 by using =IF(P2>=1,M2) but cant work our how to add in the OR Q2??

 

omclean_0-1643822672569.png

 

1 Reply

@omclean 

Select S2:U2.

Enter the following formula. If you are not using Office 2021 or Microsoft 365, confirm the formula with Ctrl+Shift+Enter.

 

=IF(OR(P2<>"",Q2<>""),M2:O2,"")

 

Fill down.