View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keniesha Keniesha is offline
external usenet poster
 
Posts: 2
Default Formula to display data if it meets multiple criteria

I have a workbook with several worksheets, one that has the data, and the
other that displays the results (report). I have 4 ranges of data - 0-19.9,
20-29.9, 30-39.9, 40-49.9)

My data sheet shows actual data (ex. 15.9 or 37.2) What kind of formula can
i use to get the actual data to show up under the range that it falls under?
So if someone has a 16.3, it would show up under the appropriate column on
the report page.

I hope this doesn't sound confusing.....I appreciate any help!