help with functions
 

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!

help with functions
 

thejellybean66 wrote...
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))

?

help with functions
 

"Harlan Grove" wrote:

thejellybean66 wrote...
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))

?

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!

help with functions
 

"Harlan Grove" wrote:

thejellybean66 wrote...
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))

?

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

help with functions
 

"thejellybean66" wrote in message
...


"Harlan Grove" wrote:

thejellybean66 wrote...
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))

?

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

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

help with functions
 

"Harlan Grove" wrote in message
oups.com...
thejellybean66 wrote...
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))

?

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

help with functions
 

maybe
=max(10,k20*r24)
--
*****
birds of the same feather flock together..



"thejellybean66" wrote:



"Harlan Grove" wrote:

thejellybean66 wrote...
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))

?

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

help with functions
 

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!

"driller" wrote:

maybe
=max(10,k20*r24)
--
*****
birds of the same feather flock together..



"thejellybean66" wrote:



"Harlan Grove" wrote:

thejellybean66 wrote...
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))

?

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