+ Reply to Thread
Results 1 to 3 of 3

Can a negative value automatically be changed...

  1. #1
    Registered User
    Join Date
    12-06-2015
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    79

    Question Can a negative value automatically be changed...

    I've been trying to figure out a formula that can, automatically, change a negative value, when a formula calls for it, EX:

    Simple formula: =50.99-65.99 = -15

    I want the formula to automatically turn that negative value into a 0, or something else that relates to the negative value not being a factor.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,953

    Re: Can a negative value automatically be changed...

    b1=abs(50.99-65.99)
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,582

    Re: Can a negative value automatically be changed...

    =max(50.99-65.99,0)
    =max(a1-b4,0)
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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. Can the Date is Changed Automatically
    By Webtekr in forum Word Formatting & General
    Replies: 4
    Last Post: 03-23-2018, 09:22 PM
  2. Automatically Run a Macro When any cell changed
    By tcy1227 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2012, 05:44 PM
  3. Replies: 2
    Last Post: 08-11-2010, 10:09 AM
  4. i want serial numbers should be changed automatically
    By naughtyboy in forum Excel General
    Replies: 4
    Last Post: 08-08-2006, 02:35 PM
  5. In Excel, how can a range of Pos #'s be changed to negative num
    By Stuart Millner in forum Excel General
    Replies: 2
    Last Post: 01-13-2006, 01:15 AM
  6. [SOLVED] How can I automatically highlight a cell that has changed value
    By JackCig in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2005, 02:45 PM
  7. Replies: 1
    Last Post: 11-26-2005, 03:10 PM
  8. [SOLVED] How do I get a date changed automatically
    By AmyR in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2005, 10:06 AM

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