IT KINDA WORKED. EXCEPT IT LOOKS LIKE EACH ADDITIONAL 100 IS GIVING ME 2
POINTS INSTEAD OF ONE. AND THE RULES READ THE FIRST $800=2 PTS. AND EACH
ADDT'L $100=1.

Govind wrote:
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.

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.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1