Feb 02 2022 09:25 AM
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??
Feb 02 2022 12:35 PM
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.