+ Reply to Thread
Results 1 to 4 of 4

Finding a percentage difference of 2 values

  1. #1
    Registered User
    Join Date
    06-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Finding a percentage difference of 2 values

    HI

    This seems simple ,but the formulas I have found on net dont seem to look correct.

    I get raw data each week and I turn those numbers into a percentage

    For example

    I need a formula to calculate and display the percentage difference of column F and Column N.
    It should show if the column F went up in percentage or if it went down.

    so last week was 10.8% this week was 7.7% . Show the difference in percentage. The percentage went down so its -3.1%

    How do I display this?

    I ve attacheda photo help better assist in the answer.ATT00001.gif
    Thanks in adavance

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Finding a percentage difference of 2 values

    The raw change is 3.1% but the change between weeks is a negative 28.7%

    (10.8 -7.7)/10.8

    Is this what you are asking. I am a bit unsure.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Finding a percentage difference of 2 values

    The raw is fine. I over complicated the situation. Thanks.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Finding a percentage difference of 2 values

    =f4-N4 and copy down

+ 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. Finding Values Difference when values are ever changing
    By Gamerxx13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2013, 08:23 PM
  2. Pivot Table with Ordinal Values and percentage difference
    By algebr in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2013, 01:09 AM
  3. [SOLVED] Help in finding the values in difference by compairing two columns
    By shekharnyk in forum Excel General
    Replies: 2
    Last Post: 05-29-2012, 03:51 AM
  4. Show difference between values as a percentage
    By gkitf16 in forum Excel General
    Replies: 2
    Last Post: 08-31-2010, 12:12 AM
  5. Finding the percentage difference of two or more numbers
    By slr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-26-2006, 11:40 AM

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