Assign a score for a GPA

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.

Paul Newcome

Try this...

=IF(GPA@row < 3, 0, IF(GPA@row < 3.49, 2, IF(GPA@row < 3.89, 3, 4)))

Paul Newcome

Try this...

=IF(GPA@row < 3, 0, IF(GPA@row < 3.49, 2, IF(GPA@row < 3.89, 3, 4)))