Need to populate new column with range values based on existing colum with if statement

Hello,

I have an excel spreadsheet with two columns below.

High School GPA High School GPA Range
4.12
4.12
4.12
4.12
3.89
3.89
3.89
3.89
2.67
2.67
2.67
2.67


I need to populate, the 'High School GPA Range' column based on the 'High School GPA' column.
The 'High School GPA Range' should be populated with the following values:

3.5 - 4.500
3.0 - 3.499
2.5 - 2.990
2.0 - 2.490

I am guessing an If statement needs to be used.

Thanks,

LastJedi

Or another way to go:

Please Login or Register  to view this content.