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




"Trisha V via OfficeKB.com" wrote in message
...

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
point,
if they increase it by %50 they get 2 points, by %75, 3 points, and %100,
4
points.... can you figure that one out for me please?

RagDyer wrote:
How about:

=CHOOSE(--LEFT(G9),1,2,3,4,5,6,7,8,9,10)
OR
If you have numbers larger then 1,000 and smaller then 100, try this:

=CHOOSE((LEN(G9)=4)*10+(LEN(G9)=3)*LEFT(G9),1,2 ,3,4,5,6,7,8,9,10)

Im working on a formula that looks somewhat like this:

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

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,I F(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

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

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

I TRIED THE SECOND ONE AND IT WORKED....WOW, THANK YOU...

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

CAS SOMEONE WITH THE FIRST ONE PLEASE...

Trisha V wrote:
I TRIED THE SECOND ONE AND IT WORKED....WOW, THANK YOU...

Tricia,

[quoted text clipped - 24 lines]

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


--
Message posted via http://www.officekb.com

Trisha,

"CAS SOMEONE WITH THE FIRST ONE PLEASE..."

Sorry, does not compute! Syntax error.

Henry

"Trisha V via OfficeKB.com" wrote in message
...
CAS SOMEONE WITH THE FIRST ONE PLEASE...

Trisha V wrote:
I TRIED THE SECOND ONE AND IT WORKED....WOW, THANK YOU...

Tricia,

[quoted text clipped - 24 lines]

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


--
Message posted via http://www.officekb.com