•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Problem with assessing scores
Our take
If you're looking to assess scores and categorize them into specific ranges, a straightforward approach can simplify your formula. Instead of overcomplicating things with multiple conditions, consider using a combination of the `IF` function to clearly define your score ranges. For instance, you can create a formula that checks if the score falls within defined intervals and returns the corresponding mark. By streamlining your formula, you can easily transform your data into actionable insights, making your spreadsheet more effective and user-friendly.
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]
Read on the original site
Open the publisher's page for the full experience
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