calculation
 

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

calculation
 

With the number of days in jail in A1 try:

=CEILING(A1+1,4)/4*(A13)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"behillj" wrote in
message ...

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

calculation
 

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