Hello all,

I need help in trying to calculate a students attendance where is the student is Late for 3 days is considered as one day absent and 6 days is 2 days absent and so on (multiple of 3) [Cell AI]. It will be deducted from the number of days present [Cell AA:AB]. So i did =IF(MOD(AI17,3)=0, AA17-1,AA17). But that only calculates if his attendance is Late for 3 days. How do i modify it so that if the student is late for 6 days, the attendance of present is deducted 2 days and so on?

Any help is greatly appreciated.

Thanks

Zadilattendance.jpg