View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Casey D
 
Posts: n/a
Default Return multiple scenarios

I am trying to write a formula that will look at a cell and return one of
eight possible values depending on the cell value. Specifically, all base
cell values are between 0-360, and I want a formula that will look at the
value and determine if it is equal to 0, greater than 0 but less than 90,
equal to 90, greater than 90 but less than 180, etc., and return a different
response for each of the 8 possibilities. Is this possible?

Thanks,
Casey