I understand..in fact I checked with 950 and it gave me 4 points. Is there
that it wont do that since I need those numbers to be exact?

Govind wrote:
Hi,

For each additional above 800, it will give only one point. However,
note that above 800, it rounds off the variance to nearest 100. For eg.
if the sales is 960, it might give 4 points (2 for 800, and 2 (960 less
800 rounded to nearest 100) for above 800).

Let me know how you want that to be rounded off and i can modify the
formula accordingly.

Regards

Govind.

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
[quoted text clipped - 17 lines]
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