View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
readystate readystate is offline
external usenet poster
 
Posts: 25
Default Formula with minimum & maximum values

I am trying to create a formula that will multiple two cells (ex: A8*A9) but
I want to make sure the final value is greater than or equal to zero and less
than or equal to 400. How would I do this? I appreciate your help.