Creating a Point System Spreadsheet

1. Decide on the ranges and corresponding points.
2. Create a table with the ranges and points.

1. Column 1: "Range"
2. Column 2: "Points"

3. Use the IF function in the cell where you want to display the points.
4. Syntax: IF(condition, value_if_true, value_if_false)
5. Use the AND function to test whether the rate falls within a certain range.
6. Syntax: AND(condition1, condition2, ...)
7. Example formula: 8. Adjust the ranges and points in the formula based on your needs.