Hello.
Background:
Nicole wants to get a job. In order to get one, her unexcused absence rate cannot be more than 10%. Nicole's rate is 13.77%. The only way to lower her unexcused rate is for her to go to school and class on time. As the number of day increase, her unexcused absence rate will decrease, as long as she is not late or has any unexcused absences. I need a formula to tell me how many days of school will it take for Nicole's rate to go from 13.77% down to 10%?
Background:
Nicole wants to get a job. In order to get one, her unexcused absence rate cannot be more than 10%. Nicole's rate is 13.77%. The only way to lower her unexcused rate is for her to go to school and class on time. As the number of day increase, her unexcused absence rate will decrease, as long as she is not late or has any unexcused absences. I need a formula to tell me how many days of school will it take for Nicole's rate to go from 13.77% down to 10%?
- As of today, there are 78 days of school left
- School is 6.5 hours a day
- Attendance is checked on a monthly basis, for all students
THIS EXCEL ATTENDANCE.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | 02/05/25 | |||||||
2 | DECEMBER | JANUARY | ||||||
3 | Nicole | 0.01 | 13.77 | |||||
4 | Mary | 0.01 | 0.01 | |||||
5 | Martha | 6.29 | 10.25 | |||||
6 | John | 2.46 | 2.27 | |||||
7 | Matthew | 2.91 | ||||||
8 | Luke | 18.22 | ||||||
9 | Mark | 0.01 | ||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A1 | A1 | =TODAY() |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
E3:F9 | Cell Value | >15.01 | text | NO |
E3:F9 | Cell Value | between 11 and 15 | text | NO |
E3:F9 | Cell Value | between 6 and 10.99 | text | NO |
E3:F9 | Cell Value | between 0.01 and 5.99 | text | NO |