Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Brian Entz Author

Level 1

10 points

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 9:24 PM

Reply

Best reply

Level 7

20,537 points

Posted on May 8, 2019 12:21 AM

Hi Brian,

Try this.

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

Regards,

Ian.

View in context

Similar questions

2 replies

Best reply

Level 7

20,537 points

May 8, 2019 12:21 AM in response to Brian Entz

Hi Brian,

Try this.

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

Regards,

Ian.

Reply

Brian Entz Author

Level 1

10 points

May 8, 2019 9:58 PM in response to Yellowbox

Thanks. Great. Perfect.

Reply

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 ID.

Learn more Sign up