Hi

Try
=IF(A1<120,"",10+(INT((A1-120)/30)*10))

--
Regards

Roger Govier


"JaB" wrote in message
...
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