+ Reply to Thread
Results 1 to 3 of 3

Percentage calculation from negative numbers

  1. #1
    Registered User
    Join Date
    02-17-2021
    Location
    Helsinki, Finland
    MS-Off Ver
    365
    Posts
    31

    Question Percentage calculation from negative numbers

    QUESTION 1:
    Calculating 10% of a Total. If the Total is negative, the Output should be set to "0". How to set this in formula?
    Tried SUMIF, but without success.

    QUESTION 2:
    Percentage calculation when the number is negative. Can't make it to work.
    Now have a formula: =SUM(-E14*$E$15) E14 is the negative number, had to add "-" sign in front of it to make it work, but this can't be the solution.
    What is?

    Example file enclosed. Any help ?
    Attached Files Attached Files
    Last edited by Tsinos; 09-27-2022 at 04:51 AM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,481

    Re: Percentage calculation from negative numbers

    E8:
    Please Login or Register  to view this content.
    E16: 10% of negative is negative?
    Please Login or Register  to view this content.
    If it does not work, what is your expected output of E16?
    Quang PT

  3. #3
    Registered User
    Join Date
    02-17-2021
    Location
    Helsinki, Finland
    MS-Off Ver
    365
    Posts
    31

    Re: Percentage calculation from negative numbers

    Thanks Bebo021999!
    Q1: The MAX solves this. Thank you so much.
    Q2: My bad. I have been looking at the percentages too long. This is OK, no need to change anything.

    Thanks and be safe!

+ 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. Replies: 3
    Last Post: 10-08-2020, 01:37 PM
  2. Calculate percentage of positive and negative numbers for a pie chart
    By splinters in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2019, 05:36 PM
  3. Percent to Budget Calculation with Negative Numbers
    By tbfla in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-27-2017, 01:28 PM
  4. [SOLVED] wrong calculation due to negative numbers?
    By loopiloo in forum Excel General
    Replies: 7
    Last Post: 12-06-2015, 11:54 AM
  5. adding negative numbers in a revenue calculation
    By dannig in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-01-2015, 01:27 PM
  6. [SOLVED] Percentage of a Goal / Actual with Negative Numbers
    By Rwilliams_09 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-08-2013, 04:43 PM
  7. [SOLVED] How to place parenthesis around a negative percentage calculation.
    By Kay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2006, 03:55 PM

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