Formula to calculate a field in payroll

[Ammaduddin]

Newbie excel user here,

I am trying to create a formula that would automatically calculate the late deductions.
The general rule is, if you're late for three days, one whole day's pay would be deducted. So basically, it would run as a multiple of 3.

3 Lates = 1 whole day's deduction.
4 Lates = 1 whole day's deduction.
5 Lates = 1 whole day's deduction.
6 Lates = 2 whole day's deduction.

Like this.

[JohnTopley]

try

=INT((A2-1)/3)+1

A2= number of "lates"

[Ammaduddin]

Thank you.

I tried =INT((A2-1)/3)+1 but there's a little problem, it is also returning 1 if the number of lates is 1 or 2. The point is if the number of lates is 1 or 2, it shouldn't be counted at all. Similarly, if there are four lates, it should still return 1 and same goes for 5.

I initially used a formula, =IF(MOD(I8,3)=0,I8/3,0) but unless its a multiple of 3, its returning 0.

[JohnTopley]

Try

=INT(A2/3)

[Ammaduddin]

It worked!

Thank you so much sir!