View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stellarblue11
 
Posts: n/a
Default Logical functions to calculate points


I am trying to calculate points for a sales program based on YOY %
change with the following criteria:

2 – 4.99% - 2 pts
5 – 9.99% - 5 pts
10 +% - 10 pts


Any suggestions on how to format a logical function to effectively
represent the data?

Thanks in advance!


--
stellarblue11