View original (French)

=SI(A1<=0; 0; A1)

Solved
coiffeur Posted messages 398 Status Member -  
 Shao -
Hello,

my question is probably simple and silly but I can't find the answer

I would like in Excel, when the result of a calculation is less than or equal to 0, that the displayed result is 0

thank you in advance for your response and happy holidays 
Configuration: P4 2.8 Ghz 1 Go of ram win XP sp2 DD 160 freebox 4 (ethernet) not unbundled

3 answers

  1.
    yofa Posted messages 1245 Status Member 207
     
    Hello,

    Try to use an = IF

    = IF (YourCalculation <=0; 0; YourCalculation)

    For example

    = IF ( (5-4) <=0 ; 0 ; 5-4 )

    It also works with cells
    --
    Don't hesitate to mark your topic as resolved if that's the case! ^^
    14
    1. TOT127 Posted messages 1045 Status Member 96
       
      Hello! I'm reactivating this post a century later. I used your formula, and it worked for me. So I have: 1 1 1 FALSE 1 11 FALSE. Can we create a forum type "put 1 if... and 0 otherwise?" To avoid these false...
      0
    2. TOT127 Posted messages 1045 Status Member 96
       
      You're welcome!
      0
    3. yoyo
       
      perfect
      0
    4. Shao
       
      Thank you very much!
      0