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