Forum Discussion
IF formula help
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...
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.