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
--
Gary's Student


"behillj" wrote:


Can anyone tell me how to create a table of some sort. what I need is
this.
This table will be used as follows for our attorneys to calculate
credits earned in jail. this is what their log looks like: It goes by
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 something
calculate credits days earned.


--
behillj
------------------------------------------------------------------------
behillj's Profile: http://www.excelforum.com/member.php...o&userid=35392
View this thread: http://www.excelforum.com/showthread...hreadid=551673