Assign a score for a GPA
Options
Charlene Stacy
✭✭✭✭✭
I need a formula that says, IF GPA column less than 3.0 assign a 0, if it is 3.0  3.49 assign 2 pts, if it is 3.5  3.89 assign 3 pts and if 3.9  4.0 assign 4 pts
The formula I'm using is, =IF(GPA@row, <3, 0, =IF(GPA@row, =3  3.49, 2, =IF(GPA@row, =3.5  3.89, 3, IF(GPA@row, =3.9  4, 4))))
Thanks for the help.
Best Answer

Try this...
=IF(GPA@row < 3, 0, IF(GPA@row < 3.49, 2, IF(GPA@row < 3.89, 3, 4)))
Answers

Try this...
=IF(GPA@row < 3, 0, IF(GPA@row < 3.49, 2, IF(GPA@row < 3.89, 3, 4)))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!