Results 1 to 5 of 5

Do not display negative numbers

Threaded View

  1. #1
    Forum Contributor thompsy121's Avatar
    Join Date
    09-25-2008
    Location
    Newcastle upon Tyne - UK
    MS-Off Ver
    Office 365
    Posts
    119

    Do not display negative numbers

    Hi All,

    I have a very simple formula which is basically one cell minus another "=A1-B1".

    When the values are equal, the cell this formula is in will display a zero. However, when the subtracted figure is greater than the first figure, i will then get a minus figure E.g. 10-11 = -1.

    How can i make it that when the formula result is less than zero (i.e. a minus number) the figure displayed stays at zero but still using the minus funciton?

    Basically once it hits zero i need it to stop subtracting.

    This may be really simple but i cant figure it out.

    Thanks
    Last edited by thompsy121; 10-19-2008 at 08:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Get Sum of Positive & Negative Numbers Separately.
    By Prem in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 06-10-2013, 05:58 AM
  2. Separating positive and negative numbers?
    By djk123 in forum Excel General
    Replies: 1
    Last Post: 03-04-2008, 04:49 AM
  3. Lookup chart problem with negative numbers
    By Fisherprice in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-30-2007, 05:05 PM
  4. Lookup not picking up negative numbers
    By Mindtrap in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2007, 06:59 PM
  5. Converting Negative Numbers to 0's
    By DangerMouse in forum Excel General
    Replies: 3
    Last Post: 01-12-2007, 06:19 AM

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