+ Reply to Thread
Results 1 to 5 of 5

Percentage Difference

  1. #1
    Registered User
    Join Date
    09-23-2011
    Location
    UAE
    MS-Off Ver
    Excel 2019
    Posts
    29

    Percentage Difference

    Hi guys, I've been doing trial and errors with my problem using the percentage formulas from this forum.

    I need to know the percentage between the difference of two numbers.

    To make it simple, for exmaple:

    a1=100
    b2=50
    c2= i want to show that b2 is the 50% of a1, but i dont want c2 to be in percentage format. just general or number with no decimal.


    i will be using this in something with higher values like

    a1=5609
    b2=5160.28 *i used a calc to deduct 8% from a1*
    c2=here i want the value to be displayed as "8"

    Thanks in advance. Will post too, if I manage to solve it myself.

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

    Re: Percentage Difference

    =100-((b2/a1)*100)

  3. #3
    Forum Contributor CheshireCat's Avatar
    Join Date
    10-11-2011
    Location
    Victoria, Canada
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    258

    Re: Percentage Difference

    Try this:

    Please Login or Register  to view this content.
    Docendo discimus.

  4. #4
    Registered User
    Join Date
    09-23-2011
    Location
    UAE
    MS-Off Ver
    Excel 2019
    Posts
    29

    Re: Percentage Difference

    thanks JieJenn for that and CheshireCat for the simplified formula.

    let me clarify one thing though. i mistakenly wrote b2 and c2 and got myself confused, but figured it out.

    it should be like this.

    a1=100
    b1=50
    c1=(1-B1/A1)*100

    THANKS!

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Percentage Difference

    ?????
    w/o calculating B2

    =((A1-(A1-B2))/A1)*100
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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