Formulas and Functions
These tips cover a variety of tasks related to formulas and functions in Microsoft Excel.
IF Function Comparison Operators
The logic test section of an Excel IF function is always a comparison between two values. To accomplish this, a “comparison operator”, such as the greater than symbol ( > ), is always placed between the two amounts being compared. This article is a handy list of the different comparison operators that can be used in Excel IF functions.
The logic test section of an Excel IF function is always a comparison between two values. To accomplish this, a “comparison operator”, such as the greater than symbol ( > ), is always placed between the two amounts being compared. This article is a handy list of the different comparison operators that can be used in Excel IF functions.
Using Cell References in Excel Formulas
Cell references describe the location of a cell in an Excel spreadsheet. These cell references can be used in formulas. Excel will calculate the answer for the formula using the data located in the cell.
Cell references describe the location of a cell in an Excel spreadsheet. These cell references can be used in formulas. Excel will calculate the answer for the formula using the data located in the cell.
#DIV/0! - Divide by 0 Error
#DIV/0! - Divide by 0 errors indicate an error in a formula. This article discusses the causes and cures for this common problem.
#DIV/0! - Divide by 0 errors indicate an error in a formula. This article discusses the causes and cures for this common problem.
##### Error Message
A ##### error message in Excel can be caused by several factors. This article discusses the causes and cures for this common error in Excel.
A ##### error message in Excel can be caused by several factors. This article discusses the causes and cures for this common error in Excel.
#REF! - Invalid Cell Reference Errors
A #REF! error message in Excel refers to an invalid cell reference. Read the article to find the causes and cures for this common problem.
A #REF! error message in Excel refers to an invalid cell reference. Read the article to find the causes and cures for this common problem.
#NULL! - Null Error
#NULL! Null errors occur in Excel. This article covers the causes and cures for #NULL! errors in Excel spreadsheets
#NULL! Null errors occur in Excel. This article covers the causes and cures for #NULL! errors in Excel spreadsheets
"What if" Questions and Excel Formulas
"What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions are very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.
"What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions are very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.
Show Formulas in Excel
Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas.
Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas.