How to use the IF function

[picaso]

Hi to all,
please help.

I use the function if and sometimes the result is false. And I would need to add a condition to my formula with the function if that when I come out false so that the result is zero.

do you know how to do it?

Thanks

[Pete_UK]

It would help if you gave us the formula that you are currently using.

In general, you could do this:

=IF(your_condition, your_TRUE_result, 0)

Hope this helps.

Pete

[FDibbins]

IF statements have 3 arguments....

=if(test-to-perform, do-this-if-test-is-true, do-that-if-test-is-false)

So in your case, it would be something like...

=if(test-to-perform, do-this-if-test-is-true, 0)