View original (French)

Put 0 instead of "FALSE" on excel

Solved
attila4 -  
 attila4 -
Hello,
I'm asking my last question after this I won't bother anyone anymore

I have a calculation with a condition and when the condition is not met, it shows "FALSE" and I would rather it show 0€ or 0.

My calculation line is as follows:
B9=IF((C4>B21),SUM(C4-B21)), I know I'm missing something but I can't figure it out.

Does anyone have the solution? After this, I won't ask anything else

Thank you in advance 
Configuration: Windows Vista Firefox 3.5.3

2 answers

  1.
    pijaku Posted messages 13513 Registration date   Status Moderator Last intervention   2 773
     
    Hello,
    If formula:
    IF(logical test; value if true; value if false)
    In your case, you omitted the "value if false" and therefore Excel returns "FALSE" as the case may be.
    Your formula is therefore:
    =IF(C4>B21;SUM(C4-B21);0)
    --
    Best regards,
    -- Anything worth doing is worth doing well --
    1
  2. attila4
     
    Thank you, it's exactly what I just found out right now... Thanks again, it reassures me in this choice of calculation
    this forum is great!
    Thanks again!
    1