•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Assign letters to numerical scores without IF
"Assign a grade based on the Score (Column B): >=90 is 'A', >=80 is 'B', otherwise 'C'. Do this without using the IF function. The formula in cell C2 will need to work when copied down the Target column."
I don't think this is the right way to solve this, but I used =CHAR(106-ROUNDDOWN(B2/10)) and it worked! Curious if anyone has the "right" formula to solve it.
Link to puzzle: https://cellout-game.web.app/
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#rows.com
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#Excel alternatives
#grade
#score
#Column B
#formula
#A
#B
#C
#IF function
#cell C2
#numerical scores
#ROUNDDOWN
#CHAR
#puzzle