Q:

Excel nested IF formula

I want to set a formula that incorporates my school's attendance policy:  

3 tardies = 1 unexcused absence
6 tardies = 2 unexcused absences
and so on  

The cell must reference not only the cell with the Tardy count, but also the attendance worksheet in the same workbook, and must add the two values.  For example, if the attendance page shows 1 unexcused absence and the tardy count shows 7 tardies, the formula needs to return 3.
This is what I've got: 
 =SUM(Attendance!O9+(IF(J4>=3,1,IF(J4>=6,2,IF(J4>=9,3,IF(J4>=12,4,))))))  

It works for 4 tardies and 1 unexcused absence, but continues to return 2 for 7 tardies and 1 unexcused absence.  
What am I missing?    

A:

Much easier than using If/Then:
=Attendance!O9+(Int(J4/3))
The Int function returns the floor integer of the calculation, J4/3.  So, if J4 = 7, the result is 2. If J4=9, the result is 3, etc.

