calculation

  • Thread starter Thread starter behillj
  • Start date Start date
B

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
 
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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
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
 
Back
Top