calculation

[behillj]

Can anyone tell me how to create a table of some sort. what I need i
this.
This table will be used as follows for our attorneys to calculat
credits earned in jail. this is what their log looks like: It goes b
4 days at a time.

Days in Jail Credits Days Earned
1 0
2 0
3 0
4 2
5 2
6 2
7 2
8 3
9 3
10 3
11 3
The attorneys would like to type in the days in jail and have somethin
calculate credits days earned

 

[Sandy Mann]

With the number of days in jail in A1 try:

=CEILING(A1+1,4)/4*(A1>3)

--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk

 

[Gary''s Student]

Enter days in jail starting in A2 and in B2 enter:

=IF(ROUNDDOWN(A2/4,0)=0,0,ROUNDDOWN(A2/4,0)+1)

and copy down