Hi,

Use

=IF(A1<800,0,MIN(10,2+(ROUND(A1-800,-2)/100)))

where the sales are in cell A1.

For the increase above 800, the increased is rounded off to the nearest 100.

Regards

Govind.

Trisha V via OfficeKB.com wrote:
how would I do a formula if the rules for the contest that Im working on read
like this...If you sell $800 you get 2 points and each additional $100 you
sell you get an additional $100 to a max of 10.