To test if a number in A1 is greater than zero and less than 10 use AND A10A1. The IF function in Excel returns one value if a condition is true and another value if its false. Combined with the logical functions such as AND OR and NOT the IF function has even more value because it allows testing multiple conditions in desired combinations.
The dialog box takes care of the syntax such as placing comma separators between arguments and surrounding text entries in quotation marks.
In this tutorial we will focus on using IF. To edit a formula click in the formula bar and change the formula. There are two ways to enter formulas in Excel. How to use OR Function.