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