I would like to get answers YES or NO for this formula
=sum((Y4/(G4+M4+O4+Q4))
if Sum = <1=YES (I couldn't put equal sign under< but it must be there )
-
if Sum = >1 = NO
I have no idea if Excel can do this and I really appreciate your help.
I would like to get answers YES or NO for this formula
=sum((Y4/(G4+M4+O4+Q4))
if Sum = <1=YES (I couldn't put equal sign under< but it must be there )
-
if Sum = >1 = NO
I have no idea if Excel can do this and I really appreciate your help.
Try like this
=IF(Y4/(G4+M4+O4+Q4)>1,"No","Yes")
Audere est facere
Thank you very much!
If the sum of G4+M4+O4+Q4 equals zero the formula will not return Yes or No, but a divide by zero error (#DIV/0!).
You should use the IFERROR function to return a default value if this error occurs
=IFERROR(IF(Y4/SUM(G4,M4,O4,Q4)>1,"No","Yes"),"")
Another way:
=IFERROR(LOOKUP(Y4/SUM(G4,M4,O4,Q4),{-1,1},{"Yes","No"}),"")
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks