A If then running count

K

kentamos

I am trying and just cannot get it.

I am trying to get a formula that does this:

If have cell n3 at numbers up to 9 then cell v3 I want to read "1"
If have cell n3 at numbers up to 14.9 then cell v3 I want to read "2"
If have cell n3 at numbers up to 19.9 then cell v3 I want to read "3"
If have cell n3 at numbers up to 24.9 then cell v3 I want to read "4"

and so on.

My attempt is to make the numbers increase by 1 when counting by 5.

can anyone help me on this.
 
N

NoCLUE

Well that does seem to work.. but from 0-5 the number needs to read
"------" as no extra tickets kick in til the number reaches 5.
 
N

NoCLUE

maybe read this way

if the tickets count is 0-4.9 then "-----"
from 5 to 9.9 then 1
from 10-14.9 then 2
from 15-19.9 then 3

and so on.
 
Top