For Every 20 Add 1

[studiostustar]

Alright, I have another one here...

I want to add 1 to B19 for every multiple of 20 in A19. It has to be every 20 exactly, so B19 should read 0 until I type 20 in A19, and then it should read 1 until I type 40, etc.

I appreciate the quick response I received earlier, and any help here is much appreciated as well!

[Special-K]

Isn't this simply

in B19
=INT(A19/20)

[studiostustar]

Yep, that did it! I was wasting time trying to get it work using CEILING. Thanks a bunch!

[martix]

Please Login or Register  to view this content.

Should do.

[rollis13]

Another try:

=ROUNDDOWN(A19/20,0)

[studiostustar]

Ok, here's a follow-up. Now I would like B19 to increase by one every time 20+B14 is entered into A19. For example, B14's value is 4, so every time A19 reaches 24, B19 should increase by 1. I've been trying to get it to work but once again I'm stumped. Thanks in advance!

[Ace_XL]

Maybe..

=INT(A19/(20+B14))

[studiostustar]

That did it! Thanks again!