View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UnisourceforNPH UnisourceforNPH is offline
external usenet poster
 
Posts: 2
Default How do I compare a result to a range of values?

I have a percentage (26.9%) that I need to compare to a table to see what
amount of bonus my group receives.
(ie 0-22.5%=$7200, 22.6%-23.8%=$6600) and so on. So I need to be able to
return a bonus value for whenever the percentage falls.