+ Reply to Thread
Results 1 to 2 of 2

Percentage question

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    Illinois
    MS-Off Ver
    Microsoft 360
    Posts
    58

    Percentage question

    This should be easy but for some reason I just can't think of the formula. Here is a simple example ... If I know that I want to have $1,000.00 left over after I give away 10% of my money, how much do I need to start with? Thanks, Joe

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Percentage question

    Hi Joebell,

    I used to teach math. The first step to this problem is to guess an answer. I'd guess something like $1500 because I know it needs to be 1000 when I get done. Then 10% of 1500 = 150. So I start with 1500 and give away 150 or I have left 1500 - 150 = 1350. So Darn!! I need it to be exactly 1000 not 1350.

    Next guess again and try something less like 1100 and 10% is 110 so is 1100-110 = 1000?? Nope again. So WTF do I start with????

    Here is the trick... Instead of starting with 1500 or 1100 you start with X dollars and then you subtract 10% . This looks like X - .1*X is supposed to equal 1000. If you know algebra you can factor out that X from the left and X - .1X is the same as (1-.1)X = 1000. convert the (1-.1) to .9... So .9X = 1000... Divide both sides by .9 and X = 1,111.111 repeat....

    Did all that make sense??? The first part of most problems is to guess an answer. Do it lots of times so you can see what you do with the number to see if you guessed correctly. When you can't guess the correct answer, substitute an X for your guess and solve.

    Hope that helps.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Percentage % question
    By Kuler in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 09-09-2012, 01:14 PM
  2. percentage question
    By jamesjille in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-10-2011, 11:12 PM
  3. Percentage question
    By berk21 in forum Excel General
    Replies: 27
    Last Post: 01-24-2009, 12:27 AM
  4. percentage question
    By juliebenn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2008, 01:51 PM
  5. [SOLVED] Percentage Question
    By lsmft in forum Excel General
    Replies: 3
    Last Post: 02-05-2008, 06:44 AM
  6. Percentage Question
    By John1950 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 03-16-2007, 10:45 AM
  7. Percentage question
    By Logie in forum Excel General
    Replies: 2
    Last Post: 04-15-2005, 09:51 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1