+ Reply to Thread
Results 1 to 10 of 10

Calculating % difference between two % values?

  1. #1
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Question Calculating % difference between two % values?

    Hi,

    Let's say I have this weeks sales conversion expressed as a % in cell A1 and last weeks in cell A2.

    In cell A3, I want to express thye DIFFERENCE of the two conversion %'s in %.

    Cannot find a way of doing it in Excel - any help appreciated!!

    Thanks,

    Z

  2. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Calculating % difference between two % values?

    Can you please upload a sample file?

    Sounds easy.... Lets C
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Calculating % difference between two % values?

    =(A1-a2)/a2

    format as %
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Re: Calculating % difference between two % values?

    Thanks guys.. I calculated as below:

    A1 - 3.44% (this week conversion rate)
    A2 - 3.47% (last week conversion rate)
    A3 - down 0.86% WOW difference [ =(A1-A2)/A2 ]

    And another one..

    B1 - 4.37% (this week conversion rate)
    B2 - 4.24% (last week conversion rate)
    B3 - down 3.07% WOW difference [ =(B1-B2)/B2 ]

    Does they look correct?

    Thanks again!
    Last edited by zudecke; 06-19-2013 at 08:38 AM.

  5. #5
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Re: Calculating % difference between two % values?

    Can anyone proof the post above? :$

    Thanks in advance!

  6. #6
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Calculating % difference between two % values?

    I think it is not logical to get the % difference by calcualting it with % only.

    The base of difference should be calculated from the previous sale/qty of the actual data instead of just using their %
    What you think?

  7. #7
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Re: Calculating % difference between two % values?

    Hmm..

    Well it's just to provide a summary of % difference between week 1's conversion % and week 2's conversion rate..

    That's all i want - does what I calculated achieve that?

  8. #8
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Re: Calculating % difference between two % values?

    Anyone know??

  9. #9
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Re: Calculating % difference between two % values?

    It doesn#t look right to me..

    4.41%
    3.37%
    =(X7-X8)/X8 = 30.86%

  10. #10
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Calculating % difference between two % values?

    In that case ...simply

    =A1-A2

    format cell as %

    This will not give you increase/decrease over two weeks as a percentage or ratio of the last wek. It simply gives absolute increase/decrease

+ 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.6.0 RC 1