Hi

I should have made the cell holding the number, e,g 22 A1 rather than I8
(which looks like eighteen - I happened to be in column I when I was
testing)

=MIN(30,MAX(10,(INT(A1/10)*10)))

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi Freddie

Try
=MIN(30,MAX(10,(INT(I8/10)*10)))

--
Regards

Roger Govier


"FreddieP" wrote in message
...
Hi I need to write a formula that chooses from 3 different values and
returns
the one I want it to.

lets say I have 10, 20 & 30 in 3 different cells and the number I
want it
to look at is 22.

I want to say that if the number I look for is below 20 return 10, if
its
between 20 & 30 I want it to return 20 and if it's above 30 I want it
to
return 30.


How would I write this formula or at least ifsomeone can help me with
hw I
write the between 20 & 30 formula.

/Freddie