#1
|
|||
|
|||
A simple math question
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
Quote:
__________________
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 |
#5
|
||||
|
||||
Quote:
Quote:
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] |
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
Thanks Paul--I envy your math fluency and, in particular, your ability to convey the math to those not so inclined.
Mark |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Simple Mail Merge Question | Ethanflux | Mail Merge | 1 | 09-29-2013 07:21 PM |
Simple question about line space | danezcou3 | Word | 1 | 04-21-2013 05:38 AM |
A simple select for a given math formula | Jo-NathanBSChE | Excel | 1 | 04-16-2013 03:10 AM |
Simple Question, difficult task... | Jshopping | Word | 4 | 01-19-2011 03:04 PM |
Simple Envelope Question.... | cmcneill | Word | 0 | 08-17-2009 05:12 PM |