•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Problem with assessing scores
Hello, could someone help me, I don't know how to write this formula. You want to assess your score. If you have 95 then write in a cell 5 (because 5-> (90, 100]) or 82 then write 4 (because 4->(80, 90]. So for example in one side you have a column full of scores next to it you want to write which mark it belongs to. Ive tried with =if function but I think I overcomplicated it. Thanks in advance
[link] [comments]
Want to read more?
Check out the full article on the original site