+ Reply to Thread
Results 1 to 12 of 12

Twice percentage cell

  1. #1
    Registered User
    Join Date
    12-16-2013
    Location
    United States
    MS-Off Ver
    2010
    Posts
    5

    Twice percentage cell

    It has been a while since math, so I am having trouble.

    Say the cell I am referencing value is 100,000

    I need to take two percentages off of that number. First 50%, then 37% and have the value in a SINGLE cell.

    Because 100,000/1.87 is not the same thing....of course.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Twice percentage cell

    =100000-100000*0.5-(100000-100000*0.5)*0.37
    I think?

  3. #3
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,173

    Re: Twice percentage cell

    =(a1*0.5)*0.63

  4. #4
    Registered User
    Join Date
    12-16-2013
    Location
    United States
    MS-Off Ver
    2010
    Posts
    5

    Re: Twice percentage cell

    I am going to try both...lol...but they look good

  5. #5
    Registered User
    Join Date
    12-16-2013
    Location
    United States
    MS-Off Ver
    2010
    Posts
    5

    Re: Twice percentage cell

    Both gave me the same number. The ACTUAL number I am referencing is $121,755.

    How I calculate it out is....121,755/1.5= 81,170 THEN 81,170/1.37 = 59,248....I need the 59248

    Both formulas gave me 38,353.

    What i am trying to do is boil a 50% markup from 121,755 down to 81,170 then 37% markup from 81,170 down to 59248

  6. #6
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Twice percentage cell

    =(121755/1.5)/1.37

  7. #7
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,482

    Re: Twice percentage cell

    It's probably more of an arithmetic question than just Excel, but:

    y=(x/1.5)/1.37=x/(1.5*1.37)=x/2.055 In excel, this could be =A1/1.5/1.37 or =A1/2.055 or =A1/(1.5*1.37). If you wanted to put the markups into cells so they could be edited later, then replace the constants with appropriate references.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  8. #8
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Twice percentage cell

    Entia non sunt multiplicanda sine necessitate

  9. #9
    Registered User
    Join Date
    12-16-2013
    Location
    United States
    MS-Off Ver
    2010
    Posts
    5

    Re: Twice percentage cell

    I really am retarded.....This is depressing

    Cross posting bad?

  10. #10
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,482

    Re: Twice percentage cell

    Cross-posting is not necessarily bad. We just want to know when and where you have cross-posted (the rules ask you to provide the link) so that we don't waste our time/effort helping to solve a problem here that has already been solved elsewhere.

  11. #11
    Registered User
    Join Date
    12-16-2013
    Location
    United States
    MS-Off Ver
    2010
    Posts
    5

    Re: Twice percentage cell

    tnx..never knew

  12. #12
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Twice percentage cell

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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] convert a percentage cell to a normal number in another cell
    By tlacloche in forum Excel General
    Replies: 4
    Last Post: 09-26-2013, 09:28 PM
  2. Replies: 2
    Last Post: 04-04-2013, 12:44 AM
  3. Replies: 1
    Last Post: 01-13-2013, 08:39 PM
  4. Replies: 3
    Last Post: 06-08-2011, 04:27 PM
  5. Replies: 2
    Last Post: 02-01-2006, 12:50 PM

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