To get there from here We need to employ two functions and an abundance of patience. I built the formula section by section. Paste Function to avoid dropping critical elements like commas. My strategy was to make a working formula for 3.5 to 4.0 converting to 4. This was easy since I didn't need a top of the range.
Next step make the AND function.
The beauty of the spreadsheet was I could verify that the formula still worked with each addition. I referenced cell A1 as the cell I would enter the GPA in. I could change the number in A1 as I worked and check for the correct result. If a problem occurred, I knew it lay in the latest addition to the formula. Of course, I cannot just paste this formula into the database.