Assign a score for a GPA

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!