The following if statement should do the trick. Substitute your cell witht
the value for the expamples cell A1:

=IF(A1<=7,7,IF(AND(A17,A1<25),A1,25))
--
Kevin Backmann


"MarkW1307" wrote:

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!