View Single Post
 
Old 02-25-2014, 03:41 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by markg2 View Post
By what logic or rule or understanding do you know which # to divide by which #?
The answer to that is found in the way you posed your original question:
Quote:
I want to know by what % product y is > than product x
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]
Reply With Quote