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)
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)
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 !
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).
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
Thank you all so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks