Entering a letter or blank if a cell is within a range

Hi

I have a cell which shows the percentage of a score,

i have 3 further cells which are based on the the percentage score.

the first cell is the range 75% - 100%. if the score is within this range it should return P
the second cell is the range 40% - 75%. if the score is within this range it should return M
the third cell is the range 0% - 40%. if the score is less than 40% it should return S


this works fine with the IF formula, however if any of the cells are out of this range then i want to return a blank "" cell. However because the the first part of the formula is within the range it returns the P and M. Because the 3rd cell is very simple there is no issue and remains blank until the criteria is met.

=IF(J$48<100,"P",IF(J$48<75,""))MHE Assessment Sheet.xlsx
=IF(J$48<75,"M",IF(J$48<40," "))
=IF(J$48<40,"S") This formula works fine

You need to use a range:

=IF(AND(J$48<100,J$48>=75),"P","")

Try:

=IF(AND(J48>=40,J48<75),I50,"")

Thanks for the rep. Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

or do it all in one cell:

=IF(J48="","",LOOKUP(J48,{0,40,75},{"S","M","P"}))