+ Reply to Thread
Results 1 to 3 of 3

Find the percentage increase/decrease between 2 numbers.

  1. 03-04-2014, 04:01 PM #1
    brent_milne is offline
    Forum Contributor
    Join Date
    03-03-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    365
    Posts
    137

    Find the percentage increase/decrease between 2 numbers.

    I have totals in d18 and e18 and need to find the percentage increase or decrease between the 2. E18 is last year's value and D18 is this year's value. Which formula will give me what I am looking for: (D18-E18)/D18 or (D18-E18)/E18

    Thanks for any helo
    Reply With QuoteRegister To Reply
  2. 03-04-2014, 04:11 PM #2
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,645

    Re: Find the percentage increase/decrease between 2 numbers.

    I should go for =(D18-E18)/E18
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 03-04-2014, 04:17 PM #3
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Find the percentage increase/decrease between 2 numbers.

    you could use =1-(E18/D18)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Percentage Increase/Decrease
    By SathishKumar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2013, 01:53 PM
  2. Percentage Increase/Decrease
    By SathishKumar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-16-2013, 10:52 AM
  3. Formula to find percentage for a value (Increase/Decrease)
    By hecgroups in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-03-2013, 11:00 AM
  4. [SOLVED] trying to find the percentage increase/decrease using a formula
    By Modify_inc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2012, 01:23 AM
  5. Percentage Increase/Decrease
    By ianonline in forum Excel General
    Replies: 2
    Last Post: 06-24-2006, 11:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1