Percentage Problem

[Rhino]

I was never good in math class, if I was I would probably know how to do
this.

Anyway, I work for an auto parts store and I often work on price comparisons
against my competitors.

What I need to know is how do I make a formula in Excel 2000 that will show
me what percentage I need to discount my price to match the competitor.

Such as,

A B C D E
F
1 Part # Desc Our Price Competitor Difference Percentage
Difference

2 1000 Widget $12.99 $11.27 $ 1.72
????

3

4

I hope that you can understand my question, Any help would be greatly
appreciated. And I assure you that if you are my competitor I will not use
this against you. Just kidding.

Thank You
Dennis

 

[Norman Harker]

Hi Rhino!

Try:

=E2/C2

As a check:

=C2*(1-F2)

But if your competitors price can be higher than yours:

=IF(E2<0,0,E2/C2)

Calculates the discount if the price is lower but gives 0 discount if
higher.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Phillips]

Rhino,

The percentage is

=E1/C1

format as percentage for display

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Rhino]

"Thank You"

That looks much better than what I was getting.

 

[Rhino]

Thank You,

That works great.

 

[Leo Heuser]

Dennis

In F2:

=MAX(0,E2/C2%)

will return the percentage or 0,
if the competitor's price is higher
than yours.

 

[Norman Harker]

Hi Rhino!

We all have these mental blockages brought on by having been taught
three things about maths:

1. We can't do maths.
2. We don't like maths.
3. All mathematicians are descended from a long line of naval
bachelors.

Most of my time in financial maths classes is spent trying to persuade
students that only one of these statements is correct.

The real art is to check that your calculations are giving the right
answer.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.