help with functions

[Guest]

on my excel sheet: =k26*2.2046*4.55/100
if the number in this cell is less than 88, I need it to show 88.00 min and
if it is over 480, i need it to show 480.00 max. also, if the number is in
between 88.00 and 480.00, i need it to state that number. is this possible?
i could swear i have done it before! please help! thank you!

 

[Harlan Grove]

on my excel sheet: =k26*2.2046*4.55/100
if the number in this cell is less than 88, I need it to show 88.00 min and
if it is over 480, i need it to show 480.00 max. also, if the number is in
between 88.00 and 480.00, i need it to state that number. is this possible?

....

Do you mean

=MAX(88,MIN(480,K26*2.2046*4.55/100))

?

 

[Guest]

....

Do you mean

=MAX(88,MIN(480,K26*2.2046*4.55/100))

?

thanks for your reply!!!!! I put in the formula in the wrong cell and i should have clicked YES for if you answered my question! Sorry about that and thank you again! this was driving me insane!

 

[Guest]

....

Do you mean

=MAX(88,MIN(480,K26*2.2046*4.55/100))

?

sorry, i forgot to include another one in my original post...

one cell i have: =k20*r24 if this is less than 10 i need it to state 10 and
if it is greater than 10, i need it to state that number. thank you.

 

[David Biddulph]

one cell i have: =k20*r24 if this is less than 10 i need it to state 10
and
if it is greater than 10, i need it to state that number. thank you.

The suggestions for your previous question were MIN and MAX. Why not look
at the help for those functions, and work out which one you need for your
new question?

 

[David Biddulph]

...

Do you mean

=MAX(88,MIN(480,K26*2.2046*4.55/100))

?

Or another option is
=MEDIAN(88,480,K26*2.2046*4.55/100)

 

[Guest]

maybe
=max(10,k20*r24)

 

[Guest]

Thank you!!!
for some reason, i just couldn't follow the steps from excel "help" to
figure it out...i was up early yesterday and up real late...maybe i was just
a bit punchy? thanks again!