Formular to increase by 1 everytime another cell increases

[seansr]

I have an order sheet that automatically calculates the labour days based on hardware installed
so if I have 1 we can do in a ¼ day and therefore I have an order line for ¼ day and a formular =IF(D172=1, 1,0)
if more than 1 we charge ½ day and the forular on ½ day is =IF(D172 >=2, 1,0)

However I really need now
if 1 =¼ 2-4=½ 5-8 = 1 9-12 = 1.5 ect
so for every time the count goes past 4 it increases by 1

 

[pecoflyer]

Please post a sample sheet. Thx

 

[seansr]

quick example
So if C2 = 1 then c6 is 1
if C2 >=2 <5 then C7 =1
if C2 >=5<9 then C7 =2
if C2 >=9 <12 then C7 =3
if C2 >=12 <15 then C7 =4
if C2 >=15<18 then C7 =5
if C2 >=18 <21 then C7 =6
I hope that helps

 

[GraH - Guido]

Maybe =LOOKUP(C2,{0,9,12,15,18,21},{1,2,3,4,5,6})?

 

[seansr]

Thats brilliant thanks
changed so it didn't calculate for 0 or 1 only after 2. Worked out what you did so was able to change
thanks for your help

 

[bosco_yip]

Since the OP's specification as giving in post #3.



So, the Lookup formula should be :

=LOOKUP(C1,{0,1,5,9,12,15,18,21},{0,1,2,3,4,5,6,"N/A"})



Regards