What is the OR operator in Excel?

What does '$' mean in Excel formula?

Excel absolute cell reference (with $ sign) An absolute reference in Excel is a cell address with the dollar sign ($) in the row or column coordinates, like $A$1. The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves.

What is the and operator in Excel?

Concatenation Operator Ampersand (&) is the Concatenate Operator in Excel. & uses to connect the results of two expressions or Strings. We can concatenate two strings, two values or both, the result will be a string. We can use &(Ampersand) Operator to concatenate two strings.

What does the =+ mean in Excel?

=+A1+B1. It has no meaning. The "+" after "=" is superfluous. It is a carryover from Lotus 1-2-3, where formulas can be entered as +123+456 instead of =123+456.

What does @name mean in Excel?

The #NAME error in Excel occurs when you incorrectly type the range name, refer to a deleted range name, or forget to put quotation marks around a text string in a formula. This error would have been noticed several times and this can appear for various reasons, the most common being misspelled formula.