Results 1 to 3 of 3

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

Threaded View

  1. #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.

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