What is an Operator Sign in Excel

An operator sign is a symbol that indicates a type of computation between cells and/or integers and are often used in the more straightforward types of calculations in Excel. Excel distinguishes four types of operator signs: arithmetic, comparison, text and reference.

Arithmetic Operator Signs

 Sign Name Operation Example + plus addition =A1+B1 – minus substraction or negation =A1-B1 or -A1 * asterisk multiplication =A1*B1 / slash division =A1/B1 % percent division by 100 =A1% ^ circumflex exponentiation =A1^B1

Comparison Operator Signs

 Sign Operation Example = equals =A1=B1 > greater than =A1>B1 < smaller than =A1 equal to or greater than =A1=>B1 <= equal to or smaller than =A1<=B1 <> not equal to =A1<>B1

Text Operator Signs

 Sign Name Operation Example & and connects entries to create one entry =A1&” “&B1

Reference Operator Signs

 Sign Name Operation Example : colon indicating a range =SUM(A1:B1) , comma uniting separate cell references into one reference =SUM(A1,B1:C1,D1) space intersection =SUM(A1:B1 C1:D1)