On the Formulas tab in the Formula Auditing group click Evaluate Formula. As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula. The COUNT formula in Excel is particularly useful for large spreadsheets wherein you want to see how many cells contain actual entries.
Enter a formula that contains a built-in function Select an empty cell.
We want to test if the value in cell C2 is greater than or equal to the value in cell D2. Excel will check if B3 values are not equal to C3 then it returns TRUE or else it will return FALSE. EVEN rounds a number up to the nearest even number and ODD rounds a number up to the nearest odd number. How to use the Excel IF Function.