How do I use IF function in Excel?

Answer 1

The IF function is really cool and useful. The formula looks like this:

=IF(true/false test,what I want to happen if true, what I want to happen if false)

Say for example you want to find out if a number in cell A1 is greater than 0. If the number is greater than 0, I want the formula to return 1. If the number is less than 0, I want the formula to return 0. Here's what that formula would look like:

=IF(A1>0,1,0)

Answer 2

= IF ( condition, value to put in cell if true, value to put in cell if false)