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 »

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 »

How to Reference an Excel Spreadsheet in Visual Basic?

Microsoft Visual Basic (VB) is a programming language that lets you interact with Windows components including Excel. You can open and reference the cells in any Excel spreadsheet because the VB la... Read More »