SB11 --

If your data is in cell A1, then:

=IF(A1<0.02,0,IF(A1<0.05,2,IF(A1<0.1,5,10)))

hth.

"stellarblue11" wrote:


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