What does the exclamation point do in Excel formulas?

The exclamation point tells Excel to multiply the contents of the cell by itself or by 1, depending on the argument supplied. It’s often used in conjunction with the number sign for string concatenation to create a longer string from the contents of several cells (or the contents of a named range).

What does the exclamation point in formulas mean?

If you use an exclamation point in a cell reference, the cell is updated if it matches the reference. The cell value is not changed, just the display. This is known as an “insensitive” reference, as it doesn’t care whether the cell is equal to the value or the cell’s value is different.

What does the exclamation point do in excel formulas?

If you are using Excel 2007 or newer, you will have noticed some new punctuation in your formulas: the exclamation point. This punctuation marks the beginning of a logical test. If the value you are working with is TRUE, the result of the function will return TRUE; if it is FALSE, the result will return FALSE.

What does the exclamation point mean in Excel formulas?

If you want to return an error message when your worksheet contains any data that is not a number, use an Excel formula with an exclamation point. The exclamation point converts its argument to text. If the argument is a number, the value returns as is. If the argument is text, it returns “#VALUE!” If you want to prevent the error message from showing up, use the IFERROR function instead.

What is the exclamation point in Excel formulas do?

The exclamation mark is a keyword in Excel formulas that indicates logical NOT. When you use it in a logical operator, Excel treats TRUE as FALSE and FALSE as TRUE. For example, the following returns TRUE: