product x=$87
product y=$828.74

the difference=$741.71



I want to know by what % product y is > than product x

I divided 87/741.71=0.117291773=11.729% which makes NO sense. The % difference between the 2 numbers has to be vastly greater.

I've always used the preceding method to determine this kind of answer and now it appears that I may have been seriously mistaken?

Mark

The answer is that product y is greater than product x by 853%.

Assume:
A1: $828.74
A2: $87.00
A3: =(A1/A2-1), formatted as %

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Your answer gets to exactly what I do not understand--

By what logic or rule or understanding do you know which # to divide by which #?

Mark

You gave the answer yourself, as y is the largest it seems evident that the increase is given by macropod's formula

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The answer to that is found in the way you posed your original question:
Therefore, 'y' is the numerator and 'x' is the denominator.

In this case, with x=$87.00 and y=$828.74:
'x' is 10.5% of 'y' ($87.00/$828.74)*100, which makes it 89.5% less than 'y' ($87.00/$828.74 -1)*100; and
'y' is 953% of 'x' ($828.74/$87.00)*100, which makes it 853% more than 'x' ($828.74/$87.00 -1)*100.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Glad we agree

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks Paul--I envy your math fluency and, in particular, your ability to convey the math to those not so inclined.

Mark