+ Reply to Thread
Results 1 to 5 of 5

Help Understanding Formua

  1. #1
    Registered User
    Join Date
    11-02-2019
    Location
    Virginia, United states
    MS-Off Ver
    Excel
    Posts
    4

    Question Help Understanding Formua

    Hello, I have the following formula below. I was hoping someone could explain to me the <0,0 part. I am trying to figure out what it is doing. I have attached the spreadsheet I am using.

    IF((B9+C9+D9+E9-L9)<0,0,B9+C9+D9+E9-L9)
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Help Understanding Formua

    HI,
    if the calculation have a negative value than display zero, else make a calculation and display the value that is not zero
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,952

    Re: Help Understanding Formua

    If B9+C9+D9+E9-L9 is less than 0, then you want the result to return 0 instead of the negative value. If not less than 0, then add up the cells. The formula could be simplified to MAX(0,B9+C9+D9+E9-L9) or MAX(0,SUM(B9:E9)-L9).

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Help Understanding Formua

    I think you are reading it wrong. the "... <0,0 ..." is not one part. The comma is the end of the test condition part of the IF function, the zero after it is the desired result if the condition is true. When reading the formula replace the commas with "THEN" for the first one, and 'ELSE' for the second one: IF x (is true) then y else q ---> IF(x,y,q).
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    11-02-2019
    Location
    Virginia, United states
    MS-Off Ver
    Excel
    Posts
    4

    Re: Help Understanding Formua

    Thank you all 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. [SOLVED] Formua to extract data
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2022, 05:57 AM
  2. [SOLVED] formua to Extract Values
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-11-2019, 08:01 AM
  3. [SOLVED] Formua to match data
    By flupsie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-31-2018, 11:47 AM
  4. [SOLVED] simplyfing formua which uses offset and abs
    By jrtaylor in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-25-2017, 03:55 PM
  5. [SOLVED] Indirect and substitute formua with sumifs
    By EmilyB in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-17-2014, 08:56 PM
  6. SumIf Formua with two criteria
    By Gambinus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2011, 04:51 PM
  7. [SOLVED] need a formua for wages
    By pgc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2005, 07:05 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