You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
Hi Brian,
Try this.
=IF(P2="","",IF(LEN(R2)>0,R2,P2))
Regards,
Ian.
Hi Brian,
Try this.
=IF(P2="","",IF(LEN(R2)>0,R2,P2))
Regards,
Ian.
Thanks. Great. Perfect.
Kind of complicated switcharoo
