IF statement formula

J

JaB

Hi

Im hoping someone can assist me in creating a formula that does the following.

I would like it to look at a cell, and that cell contains a number greater
that 120, to return a figure of 10 for each increment of 30 over 120. For
instance, if the cell contained 121 it would return '10'. If the cell
contained 211 it would return '40' etc.

Any ideas?

Thanks
 
S

Stefi

=(INT((A1-120)/30)+1)*10

But what should the formula return if A1<=120 or it's not a number at all?

Regards,
Stefi


„JaB†ezt írta:
 
R

Roger Govier

Hi

Then replace my double quotes with a zero
=IF(A1<120,0,10+(INT((A1-120)/30)*10))
 
Top