You might have this right for what im looking for... this is what i was
working on..we sell advertising ads for the yellow pages. last year, they had
a certain ad that (lets say) was $100..this year the sales rep upsold them
$125 making that a %25 increase...i said this before..i know. the thing is I
already have the variance that calculates the % so the formula in that case
would change? right?

the same contest with the pulls is the one that has a lot of formulas needed.
a new customer would be someone that never had an ad in the yellow pages. i
just have a count of how many new customers there were for week. so if i have
3 new customers in a week, the sales rep gets a pull (or a point)...6 new
customer would = 2 pulls, 9 new customers=3, etc etc..with a max of 10 pulls.


Henry wrote:
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

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%.
[quoted text clipped - 17 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