•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#formula generator
#Excel alternatives
#score
#scores
#assess
#formula
#mark
#Excel
#function
#column
#solution
#if
#cell