+ Reply to Thread
Results 1 to 3 of 3

Thread: Variable Percentage?

  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    Idaho
    MS-Off Ver
    Excel 2007
    Posts
    8

    Variable Percentage?

    I'm not sure how exactly to explain this so I have attached a sample worksheet so you can see what I'm talking about.

    "I just need to know how to get the variable percentage of C2 - C5 to show up in E2 - E5. So, basically I want E2 to show "48" because that is 80% of 60 but I want to be able to change the precentage in D2 and have E2 adjust based on whatever percentage is entered."

    So, if the employee is allowed 60 miles, but only got 80% of those miles, I want the third cell to reflect 80% of 60. But, the percentage is going to change and will not always be even amounts (they usually are more like 75.43% or something) and I would need the third cell to reflect the accurate number based on what the percentage is.

    I hope I'm making at least a little bit of sense.
    Any help is appreciated.
    Thank you in advance!
    Attached Files Attached Files
    Last edited by GeekyGirl; 10-05-2011 at 04:59 PM.

  2. #2
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010
    Posts
    856

    Re: Variable Percentage?

    =C2*D2
    Fill that formula down from E2:E5.
    If your question has been satisfactorily addressed, please consider marking it solved. Click here to see how.

    Also, you might want to add to the user's reputation by clicking the scales icon - it's why we do what we do...

    Thomas Lafferty
    Analyst/Programmer

  3. #3
    Registered User
    Join Date
    06-30-2011
    Location
    Idaho
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Variable Percentage?

    Oh wow. Sometimes I amaze myself with how complicated I work things up in my head. Hahahaha, thank you so much. >.<

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.2.0