•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula for letter grades
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]
Want to read more?
Check out the full article on the original site
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