Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2014, 09:55 PM
macropod's Avatar
macropod macropod is offline A simple math question Windows 7 32bit A simple math question Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

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]
Reply With Quote
  #2  
Old 02-25-2014, 06:56 AM
markg2 markg2 is offline A simple math question Windows 7 A simple math question Office 2007
Expert
A simple math question
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 02-25-2014, 03:41 PM
macropod's Avatar
macropod macropod is offline A simple math question Windows 7 32bit A simple math question Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
A simple math question Simple Mail Merge Question Ethanflux Mail Merge 1 09-29-2013 07:21 PM
A simple math question Simple question about line space danezcou3 Word 1 04-21-2013 05:38 AM
A simple math question A simple select for a given math formula Jo-NathanBSChE Excel 1 04-16-2013 03:10 AM
A simple math question 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft