How to Use a Blank Cell as a Reference in an "If Statement" in Excel?

Answer Using an "if" function in Excel, you can set the contents of one cell according to another cell or cells. The criteria for an if statement to be true can be simple, as in "If cell A2 holds a value ... Read More »

Top Q&A For: How to Use a Blank Cell as a Reference in an "I...

How to Count All Rows With a Blank Cell in Excel 2007?

Sometimes when you insert data into Excel, you may leave a row or cell blank with no data. For example, if you have students who did not complete an assignment, for that assignment they would have ... Read More »

How Can I Get Rid of the 2nd Blank Page in Excel?

In Microsoft Excel, one or more blank pages may print when you print the document. This occurs for several reasons. Data cells that contain information but appear blank may be a cause. A cell th... Read More »

What is a circular reference in Microsoft Excel?

Excel Formulas and Functions involve particular rules. The smallest mistake can throw your entire entry off, and Excel will not calculate it. When your Formula or Function for example, refers to th... Read More »

How to Cross Reference Between Excel Spreadsheets?

Microsoft Excel allows references to information contained in cells on different sheets within a workbook or in a completely different spreadsheet file. The ability to link multiple spreadsheet fil... Read More »