•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula for letter grades
Our take
Are you struggling to assign letter grades based on numerical ranges in your spreadsheet? You’re not alone—many users find it challenging to create effective formulas without a solid grasp of the underlying concepts. This guide will help you transform your approach to grading with a straightforward formula that assigns letter grades based on specified ranges. We’ll break down the logic step-by-step, ensuring you not only understand how to implement it but also feel empowered to adapt it for your needs.
I'm trying to write a formula to put a letter grade in a cell based on the range of numbers in another cell. This is my first stab at it, but to be honest I barely understand how to do this.
if((C23<10),"A")OR
if(and(C24>9,C24<31),"B")OR
if(and(C24>30,C24<61),"C")OR
if(and(C24>60,C24<91),"D")OR
if(C24>90, "F")
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#AI formula generation techniques#rows.com#Excel alternatives for data analysis#Excel compatibility#cloud-based spreadsheet applications#natural language processing for spreadsheets#generative AI for data analysis#letter grade#formula#cell#range#numbers#C23#C24#if statement#and function#A#B#C#D