IF formula help

Copper Contributor

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.