View original (French)

Set to 0 if negative result

Solved
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!
Configuration: Windows XP

2 answers

  1.
    Bidouilleu_R Posted messages 1209 Status Member 296
     
    =B5-(E5*0.38)-C5-D5

    if this formula is positive; write the formula otherwise "result less than 0"

    which gives =IF(B5-(E5*0.38)-C5-D5>0;B5-(E5*0.38)-C5-D5;"result less than 0")

    A+
    3
    1. severinerl
       
      It works!!!! Thank you very much!
      0