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.
I have created this formula in cell I39:
IF(I31>I32, "WIN", IF(I31<I32, "Loss", IF(I31=I32, "draw")))
It works well but is returning "draw" if the two cells being compared are blank. I only want "draw" to show if there are actually values in cells I31 or I32 to compare, but to show nothing in cell I39 if either cell I31 or I32 is blank?. What do I add and where to make the formula work as I need it to?
Use:
IF(I31>I32, "Win", IF(I31<I32, "Loss", IF(NOT(ISBLANK(I31)),IF(I31=I32, "Draw"),"")))
(254941)
Another way:
=IFS(OR(I31="",I32=""),"", I31>I32, "WIN", I31<I32, "LOSS", I31=I32, "DRAW")
Thank you @Niel!! This worked perfectly. I had attempted many ways but not added the "NOT" in the formula!
Thank you for your advice @Badunit. This formula didn't work for me as I couldn't use the IFS function, maybe due to the age of my numbers version (version 5.2).
Apple Numbers formula help!!
