+ 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