Table 1: Past Payment Status History à Credit Points Conversion Table Past Payment Status Credit Points -2 to 0 = 5 points 1 to 2 = 4 points 3 to 4 = 3 points 5 to 6 = 2 points 7 and above = 1 point...

Table 1: Past Payment Status History à Credit Points Conversion Table
Past Payment Status Credit Points
-2 to 0   =           5 points
1 to 2    =           4 points
3 to 4    =          3 points
5 to 6     =         2 points
7 and above  =  1 point

How do I do an excel formula for a cell that have a score of -2 to 0 with 5 points, or 1 to 2 with 4 points, etc.