Set to 0 if negative result
Solved
severinerl
-
severinerl -
severinerl -
Hello,
I have a table in which a result appears.
I am not very skilled and I would like to know the formula that would show the result of my calculation if it is positive, and if it is negative, a text formula: "result less than 0" should be noted.
I have tried several types of formulas... but without success. What bothers me is that I don't know how to insert my "hypothesis" parameter into my current calculation formula which is :=B5-(E5*0.38)-C5-D5
Thank you for your help!
I have a table in which a result appears.
I am not very skilled and I would like to know the formula that would show the result of my calculation if it is positive, and if it is negative, a text formula: "result less than 0" should be noted.
I have tried several types of formulas... but without success. What bothers me is that I don't know how to insert my "hypothesis" parameter into my current calculation formula which is :=B5-(E5*0.38)-C5-D5
Thank you for your help!
Configuration: Windows XP
