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
|