Thank you so much. That one worked great. Now I just need the % one and my
boss will be real happy...lol

Govind wrote:
Hi,

If you dont want any rounding off at all, use

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

But, say the sales are 950, this would give 3.5 points. If this is how
you want the points to be given, use this.

On the contrary, if you want only completed 100's to be given points, use

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

In this case 950 will be given only 3 points, as only one 100 is
complete after 800.

Govind.

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?
[quoted text clipped - 20 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