Using the IF Function in Excel In this example, we are going to use a table containing the test marks of students. We want to use the IF statement to determine who passes and who fails.

In Excel, you can either use the ISEVEN function to determine even numbers; if the number is even, it will return TRUE; if odd, it will return false. The ISODD function determines odd numbers ...

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

Each IF function in an Excel spreadsheet returns one of two messages. The first -- the "if" message -- displays if cells meet criteria that you specify. The second -- the "otherwise" message ...

Open the Excel 2010 spreadsheet containing the information where you want to perform your count. Click on the cell where you want the result of the COUNTIFS function to appear.

Put in a way that Excel can understand, our Logical_test for the first row, department A, is C2>B2. C2 is department A’s actual amount, and B2 is department A’s budgeted amount (see the screenshot ...