Formula help, please

[Hapdawg88]

=IF(J2>75,"3",IF(J2>65,"2",IF(J2>50,"1",IF(ISBLANK(J2),"none","0"))))

J2 column holds the scores to a conditional test. Not everyone was given the test so there are some blank cells. IF the cell is blank them "none" belongs in the column if the cell has a number in it then the first IF statement applies.

When I use the formula above a "3" is returned for the blank cells. I cannot figure out why.

Thank you in advance for your help!

 

[BlueHornet]

The cells you're evaluating are probably not "blank", but have a space or some other invisible character in them. You could see that the "apparently blank" cells are truly cleared, or just change the formula to account for the fact that some cell contents are going to be " ".

 

[Fluff]

Try
=IF(J2>75,"3",IF(J2>65,"2",IF(J2>50,"1",IF(J2="","none","0"))))

 

[Hapdawg88]

The cells you're evaluating are probably not "blank", but have a space or some other invisible character in them. You could see that the "apparently blank" cells are truly cleared, or just change the formula to account for the fact that some cell contents are going to be " ".

That was it! Thank you!