formula for my driver log, thanx
 

A B C D E F G H
TOTAL WK1 WK2 WK3 WK4 TOTAL Util next Next bonus
2400 10 20 10 30 2470 30 2500
2600 30 40 20 10 2700 2300 5000

Hello and thanx in advance to anyone who can help me. I'm sure its not that
difficult, but here is my question. I keep track of deliveries for my
company. Every 2500 deliveries the driver gets a bonus(H). After that the
driver gets a bonus at 5000, 7500 etc. (G) tells the driver how many
deliveries are left until they get their next bonus. When (G) becomes a neg
number I can easily increase (H) by 2500 manually. However, I figure there
has to be a formula that will start (H) at 2500 and increase it by 2500 when
(G) goes to neg number. Sometimes I mess up and would also like (H) to back
down by 2500, (ie I accidently put 70 in (E) which raises (F) to 2510
triggering (H) to go to 5000, I would like (H) to go back to 2500 when I put
the correct # in (E) which would bring (F) below the 2500 mark.)

formula for my driver log, thanx
 

On Sat, 10 Feb 2007 23:57:00 -0800, kc wrote:

A B C D E F G H
TOTAL WK1 WK2 WK3 WK4 TOTAL Util next Next bonus
2400 10 20 10 30 2470 30 2500
2600 30 40 20 10 2700 2300 5000

Hello and thanx in advance to anyone who can help me. I'm sure its not that
difficult, but here is my question. I keep track of deliveries for my
company. Every 2500 deliveries the driver gets a bonus(H). After that the
driver gets a bonus at 5000, 7500 etc. (G) tells the driver how many
deliveries are left until they get their next bonus. When (G) becomes a neg
number I can easily increase (H) by 2500 manually. However, I figure there
has to be a formula that will start (H) at 2500 and increase it by 2500 when
(G) goes to neg number. Sometimes I mess up and would also like (H) to back
down by 2500, (ie I accidently put 70 in (E) which raises (F) to 2510
triggering (H) to go to 5000, I would like (H) to go back to 2500 when I put
the correct # in (E) which would bring (F) below the 2500 mark.)


H3: =2500*(1+INT(F3/2500))


--ron

formula for my driver log, thanx
 

thanks for the help Ron

"kc" wrote:

A B C D E F G H
TOTAL WK1 WK2 WK3 WK4 TOTAL Util next Next bonus
2400 10 20 10 30 2470 30 2500
2600 30 40 20 10 2700 2300 5000

Hello and thanx in advance to anyone who can help me. I'm sure its not that
difficult, but here is my question. I keep track of deliveries for my
company. Every 2500 deliveries the driver gets a bonus(H). After that the
driver gets a bonus at 5000, 7500 etc. (G) tells the driver how many
deliveries are left until they get their next bonus. When (G) becomes a neg
number I can easily increase (H) by 2500 manually. However, I figure there
has to be a formula that will start (H) at 2500 and increase it by 2500 when
(G) goes to neg number. Sometimes I mess up and would also like (H) to back
down by 2500, (ie I accidently put 70 in (E) which raises (F) to 2510
triggering (H) to go to 5000, I would like (H) to go back to 2500 when I put
the correct # in (E) which would bring (F) below the 2500 mark.)

formula for my driver log, thanx
 

On Sun, 11 Feb 2007 10:08:00 -0800, kc wrote:

thanks for the help Ron

You're welcome. Glad to do it.
--ron