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