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.
Hi there. Is someone able to tell me what I am doing wrong in my formula?
I am trying to say, CxD= E, however if D says "N/R-Direct Pay" the E will say "N/R".
I would much appreciate any assistance.
[Re-Titled by Moderator]
iMac 24″, macOS 15.1
Ian gave the answer. I thought I'd throw some words around it. If you reword your question as an if-then-else statement, it would be "if D says "N/R-Direct Pay" then E will say "N/R", else E will be CxD". The IF formula Ian provided comes naturally from that question.
Hi Hayley,
Try this formula in E5. Type = then
IF(D5="N/R-Direct Pay","N/R",C5×D5)
Regards,
Ian.
Thank you so much.
Thank you so much. I really appreciate all the assistance.
Formula issue with Numbers on Mac
