View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
thejellybean66 thejellybean66 is offline
external usenet poster
 
Posts: 4
Default 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!