Formula Help required!

[MarkW1307]

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!

 

[Kevin B]

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(A1>7,A1<25),A1,25))

 

[Dana DeLouis]

Just another option:

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

--
HTH :>)
Dana DeLouis

 

[MarkW1307]

Excellent, worked perfectly.
Thanks Kevin

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(A1>7,A1<25),A1,25))

 

[David Biddulph]

=MEDIAN(7,A1,25)

 

[David Biddulph]

Why test for A1>7, when you had previously tested for A1<=7 ?