help with functions

T

thejellybean66

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!
 
H

Harlan Grove

thejellybean66 said:
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?
Click to expand...
....

Do you mean

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

?
 
T

thejellybean66

Harlan Grove said:
....

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!
Click to expand...
 
T

thejellybean66

Harlan Grove said:
....

Do you mean

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

?

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

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. :)
 
D

David Biddulph

thejellybean66 said:
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. :)
Click to expand...

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?
 
T

thejellybean66

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!
 
Top