Tricia,

First one:

((B1-A1)/A1 )*100 will give the percentage increase.
((B1-A1)/A1)* 4 will give 1 for 25%, 2 for 50%, etc.
INT(((B1-A1)/A1)* 4 ) makes sure you only get whole numbers.
=IF(INT(((B1-A1)/A1)* 4 )10,10,INT(((B1-A1)/A1)* 4 )) limits it to max 10.

Second one:
Depends what you mean by "New customers" and how you are recording these.
Is someone they haven't sold to for 3 months a "New Customer"?
Is someone they haven't sold to for 6 months a "New Customer"?

Is the number of new customers recorded in a cell somewhere?

Say it's in D1
In E1, put

IF(INT(D1/3)10,10,INT(D1/3))

Henry


"Trisha V via OfficeKB.com" wrote in message
...
HMMM....I ALREADY HAVE THE C1 INFO SO HOW WOULD THE FORMULA CHANGE NOW IF
THEY GET UP TO 10 POINTS. MEANING INCREMENTS OF 25%.

HERE'S ANOTHER ONE...THIS HAS TO BE SIMPLER.. EVERY 3 NEW CUSTOMERS THE
SELL
TO THEY GET A POINT UP TO 10 POINTS... HOW WOULD I DO THAT FORMULA?


Henry wrote:
Trisha,

Assume your starting figure is in A1 & your final figure is in B1.
In C1 put
=IF(B1=A1*2,4,IF(B1=A1*1.75,3,IF(B1=A1*1.5,2, IF(B1=A1*1.25,1,0))))

Henry

I got help for this one finally...thank you though...maybe you can help
me
with another one..if someone increases an amount by %25 then they get a
[quoted text clipped - 16 lines]

WHAT AM I DOING WRONG? CAN SOMEONE PLEASE HELP ME?


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