=SI(A1<=0; 0; A1)
Solved
coiffeur
Posted messages
398
Status
Membre
-
Shao -
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
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 réponses
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! ^^
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! ^^
TOT127
Posted messages
1045
Status
Membre
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...
TOT127
Posted messages
1045
Status
Membre
96
You're welcome!
yoyo
perfect
Shao
Thank you very much!