thank you both for your input, I'll try it later tonight...

/Freddie

"Roger Govier" wrote:

Hi Carim

Just
=MIN(A3,MAX(A1,(INT(B1/10)*10)))
will suffice provided the pack sizes are always entered in ascending
size.

--
Regards

Roger Govier


"Carim" wrote in message
oups.com...
Freddie,


With your numbers in the same cells A1 A2 A3, cell to be tested is B1
:

=MIN(MAX(A1:A3),MAX(MIN(A1:A3),(INT(B1/MIN(A1:A3))*MIN(A1:A3))))

Roger's formula, once adjusted, should do the job ...

HTH
Cheers
Carim