IF Formula Assistance Required

[garymu16]

Can anyone advise me on where I am going wrong with the below forumla?

=if(J2>79,"80%",if(AND(J2<=79,J2>=50,"50/50",if(J2<50,"<50%",""))))

Basically I am trying to return 3 values based on the number in cell J2. If this number is 80 or more then return "80%". If the number in J2 is between 50 & 79 then return ""50/50" and if the value in J2 is less than 50 then return "<50".

Thx in advance

Gary

 

[brian.wethington]

=IF(J2>79,"80%", IF(AND(J2<=79,J2>=50), "50/50", "<50%"))

Try this

 

[garymu16]

Worked a treat - Thank you.

 

[barry houdini]

You don't really need AND, this should suffice

=IF(J2>=80,"80%",IF(J2>=50,"50/50","<50%"))

 

[Joe4]

Actually, the AND clause is not even necessary (if it is greater than 79, it will never get to the second level, so it is redundant to test for it again):

=IF(J2>79,"80%", IF(J2>=50, "50/50", "<50%"))

 

[brian.wethington]

Good point... I failed to remove that portion of the formula. just caught the missing end parenthesis and the fact that he did not need the last if statement. Thank you for picking up the slack.