My group has a point system where three points will amount to one strike. In column F all points are totalled, and each row is a different person. How do I have Google Sheets calculate the amount of strikes each individual has?
Google-sheets – How to have Google Spreadsheets calculate certain cells in increments
google sheets
Related Topic
- Google Sheets – Selecting a Sequence of Sheets in Google Docs/Spreadsheets
- Google-sheets – Grouping Columns in Google Spreadsheets
- Google Sheets – Calculate Score and Ranking
- Google-sheets – How to change the value of one cell in Google sheets based on what is entered into another
- Google Sheets – Create AP Style Poll
Best Answer
Just simply divide each number by the value of your increment, then round down to the nearest whole number.
Google Support: ROUNDDOWN