How do you combine 2 or more formulas with different totals?

[Trisha V via OfficeKB.com]

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

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]

 

[Trisha V via OfficeKB.com]

CAS SOMEONE WITH THE FIRST ONE PLEASE...

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

Tricia,

[quoted text clipped - 24 lines]

 

[Henry]

Trisha,

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

Sorry, does not compute! Syntax error.

Henry

CAS SOMEONE WITH THE FIRST ONE PLEASE...

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?