Kind of complicated switcharoo

For column Q that is currently empty I would like to put a formula so that the content of any cell in Q should be the number in P column to the left UNLESS there is an entry in the cell in R column to the right. In which case the Q column should read what is in R column. So Q15 should be $8000 but Q16 should be $1000.


Mac Pro

Posted on May 7, 2019 09:24 PM

Reply
Question marked as Top-ranking reply

Posted on May 8, 2019 12:21 AM

Hi Brian,


Try this.


=IF(P2="","",IF(LEN(R2)>0,R2,P2))


Regards,

Ian.

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Kind of complicated switcharoo

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.