+ Reply to Thread
Results 1 to 3 of 3

How to convert result of addition to a zero if answer is a minus figure

  1. #1
    Registered User
    Join Date
    05-04-2017
    Location
    Dorchester, England
    MS-Off Ver
    2013
    Posts
    7

    How to convert result of addition to a zero if answer is a minus figure

    Hi, I'll try to explain my problem. I'm putting together a calculator for work, which has a starting figure of 40,000, and then has three cells in which the number input is deducted from the 40,000.

    The trouble is that if the three cell's total number exceeds the 40,000, it shows as a minus figure, whereas I want the field to just show a zero, as it is basically a 'amount on which tax is now due' query, over a period of three years, in which each of the years needs to be shown.

    For context, the cells are as follows:

    G59 = 40,000
    G61 = cell figure to be deducted from 40,000
    G63 = cell figure to be deducted from 40,000
    G65 = cell figure to be deducted from 40,000
    G67 = remaining amount for tax due.

    So I've put in G59-G61-G63-G65 to find the amount due, but want the figure to autocorrect to 0.00 is the result is a minus figure.

    Please someone help!!!

    Thank you

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: How to convert result of addition to a zero if answer is a minus figure

    Use IF function
    =IF(G59-SUM(G61,G63,G65)<0,0,G59-SUM(G61,G63,G65))
    Last edited by haripopuri; 09-28-2017 at 10:21 AM.
    ________________________________________________________
    If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.

    Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.

  3. #3
    Registered User
    Join Date
    05-04-2017
    Location
    Dorchester, England
    MS-Off Ver
    2013
    Posts
    7

    Re: How to convert result of addition to a zero if answer is a minus figure

    Amazing!! Thank you so much!

+ 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. Problems showing a minus figure with an IF formula...
    By Weaselwithagun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2017, 04:31 AM
  2. [SOLVED] calculating formula with a minus figure
    By shrubfact in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2014, 01:29 PM
  3. [SOLVED] Replacing a 'minus figure' with a zero
    By Illustris13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2013, 06:08 PM
  4. [SOLVED] How to get the correct (minus) answer for a minus raised to a power
    By enginezzz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 08:44 PM
  5. [SOLVED] I neeed help on changing a minus figure so it does not show a minus
    By Kirstg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-24-2012, 11:44 AM
  6. Replies: 2
    Last Post: 01-01-2010, 07:45 AM
  7. addition calculation not giving correct answer
    By lnjr in forum Excel General
    Replies: 2
    Last Post: 02-22-2009, 05:49 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