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

Try this...
=IF(GPA@row < 3, 0, IF(GPA@row < 3.49, 2, IF(GPA@row < 3.89, 3, 4)))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Answers

Try this...
=IF(GPA@row < 3, 0, IF(GPA@row < 3.49, 2, IF(GPA@row < 3.89, 3, 4)))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 377 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!