Just another option:

=MAX(MIN(A1,25),7)

--
HTH :)
Dana DeLouis


"MarkW1307" wrote in message ...

I am trying to set a formula to achieve the following and would appreciate
any assistance:
I have a number in a cell which if less than 7 should show 7 but if greater
than 7 and less than 25 should display itself and greater than 25 should show
25.
i.e 3.4 shows 7; 9.5 shows 9.5; 28 shows 25 i can do any two of these but
not all 3. Please help!