Learn how to use the VALUE function in Excel to convert text to numbers, dates, or times. See the syntax, arguments, remarks, and examples of this function.

The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula:

The FIELDVALUE function returns all matching fields (s) from the linked data type specified in the value argument. The FIELDVALUE function belongs to the Lookup & Reference family of functions.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.

#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and it can be hard to find the exact cause of it. The information on this page shows common problems and solutions for the error.

Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

How to use the INDEX function in Excel to return a value or reference to a value within a table or range.

The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.