+ Reply to Thread
Results 1 to 2 of 2

Calculated differential positive and negative.

  1. #1
    Registered User
    Join Date
    01-16-2020
    Location
    DC, USA
    MS-Off Ver
    Office 365
    Posts
    1

    Calculated differential positive and negative.

    Good afternoon,

    I am trying to figure out a formula that will help me calculate the quarter over quarter differential. I have attahced a small example of the data however, what you dont see in my small example file is that the data is in a pivot table and I am performing the calculations in the cells adjacent. I dont think that should make a difference but wanted to mention it.

    I need this formula to calculate the differential both positive and negative. So if I had no issue 1 in the first quarter but 2 in the 2nd qaurter then I had a 200% increase. However if I had 0 issue 1's in the 3rd qaurter then we had a 200% drop in instances.

    Anyone have any ideas?

    Thanks,

    Brad
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: Calculated differential positive and negative.

    I'm a little confused. You already have a formula in your sheet for quarter to quarter comparison. Are those wrong? Which one is incorrect and what value are you expecting.

    I'm also not sure when you say, "I had no issue 1 in the first quarter..." what do you mean "no issue 1" is that short for NUMBER of issues? Are you saying 0 issues or 1 issues?

+ 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] How to sum a positive and negative number so the total is positive
    By jminty95 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-15-2017, 09:27 PM
  2. [SOLVED] Find pattern (positive, negative, positive)
    By tsakta13ole in forum Excel General
    Replies: 6
    Last Post: 06-01-2016, 05:10 AM
  3. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM
  4. Replies: 1
    Last Post: 08-14-2009, 11:17 AM
  5. Replies: 1
    Last Post: 11-20-2008, 01:52 AM
  6. Replies: 2
    Last Post: 11-13-2008, 12:35 AM
  7. Replies: 4
    Last Post: 09-26-2005, 06:05 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