Formulas

[Help9001]

this is what I’m trying to do
(If A1>0,1,)+(if A1>60,1,)+(if A1>120,1,)+(if A1>180,1,)and so on down the line
I was wondering if there is an easier way to write this so I don’t have to add 100 if statements to a cell?

 

[James006]

Hello


The very simple way is to create a table .. an use Vlookup()

HTH

 

[steve the fish]

Presuming thats a pattern then:

=ROUNDUP(A1/60,0)