I have a excel sheet with positive and negative value. I have 4 grades to be assigned. How can I use a formula to assign the grades? I have tried using the IF nested function but due to negative value I am unable to do so. I have used this formula (IF(B4>89,”A”,IF(B4>79,”B”,IF(B4>69,”C”,IF(B4>59,”D”,”F”)))))
Can you have a look at the excel sheet below? the number in bracket refers to the score.
Thank you
I think using many IFs in formula is not a good practice. I suggest to use INDEX & MATCH and create the scale on a separate sheet. Please find the attached file with my solution. This approach is more flexible. For example, as far as I know, it should be use "E" for scores which are between 0 and 30, and you can just add it to the sheet and will work.
I dont see any problem with your formula. Please see file inclosed
Nirmal D Patil
Try this: It works for me: =(IF(B7>89,"A",IF(B7>79,"B",IF(B7>69,"C",IF(B7>59,"D","F")))))
I think the problem in with the bracket symbols. See the attachments with some hypothetical random numbers.
I agree with Raoof, usually, the issues with nested IF's are with the brackets, commas etc...
I think using many IFs in formula is not a good practice. I suggest to use INDEX & MATCH and create the scale on a separate sheet. Please find the attached file with my solution. This approach is more flexible. For example, as far as I know, it should be use "E" for scores which are between 0 and 30, and you can just add it to the sheet and will work.
- Badges
- Science topic