Insert Math Symbols Into Google Sheets

Math symbols such as ∛, ∑, or ≙ can add extra visual information to your Google Sheets spreadsheets. You can insert the characters into Google Sheets using one of the three methods discussed below. Use the method that works best in your spreadsheet.

These symbols are visual only. Use the built-in functions to perform mathematical operations.

Use the CHAR Function

Find the Unicode decimal code for the shape in the table at the end of this article, and insert it using the CHAR function. For example, =CHAR(8777) inserts “NOT ALMOST EQUAL TO.”

The CHAR function inserting a mathematical operator
Not Almost Equal To

Copy and Paste

You can find the symbol you want in the table below, copy the shape, and paste it into your spreadsheet.

Use an Add-On

The Insert Special Characters add-on is the easiest way to insert mathematical symbols. Browse through all the shapes and choose the symbol you want. Then insert the character with just one click.

Using the Insert Special Characters Add-On for Mathematical Sybmols


Insert Special Characters Add-On

Table of Mathematical Operators with Unicode Decimal Codes

DecimalNameAppearance
8704FOR ALL
8705COMPLEMENT
8706PARTIAL DIFFERENTIAL
8707THERE EXISTS
8708THERE DOES NOT EXIST
8709EMPTY SET
8710INCREMENT
8711NABLA
8712ELEMENT OF
8713NOT AN ELEMENT OF
8714SMALL ELEMENT OF
8715CONTAINS AS MEMBER
8716DOES NOT CONTAIN AS MEMBER
8717SMALL CONTAINS AS MEMBER
8718END OF PROOF
8719N-ARY PRODUCT
8720N-ARY COPRODUCT
8721N-ARY SUMMATION
8722MINUS SIGN
8723MINUS-OR-PLUS SIGN
8724DOT PLUS
8725DIVISION SLASH
8726SET MINUS
8727ASTERISK OPERATOR
8728RING OPERATOR
8729BULLET OPERATOR
8730SQUARE ROOT
8731CUBE ROOT
8732FOURTH ROOT
8733PROPORTIONAL TO
8734INFINITY
8735RIGHT ANGLE
8736ANGLE
8737MEASURED ANGLE
8738SPHERICAL ANGLE
8739DIVIDES
8740DOES NOT DIVIDE
8741PARALLEL TO
8742NOT PARALLEL TO
8743LOGICAL AND
8744LOGICAL OR
8745INTERSECTION
8746UNION
8747INTEGRAL
8748DOUBLE INTEGRAL
8749TRIPLE INTEGRAL
8750CONTOUR INTEGRAL
8751SURFACE INTEGRAL
8752VOLUME INTEGRAL
8753CLOCKWISE INTEGRAL
8754CLOCKWISE CONTOUR INTEGRAL
8755ANTICLOCKWISE CONTOUR INTEGRAL
8756THEREFORE
8757BECAUSE
8758RATIO
8759PROPORTION
8760DOT MINUS
8761EXCESS
8762GEOMETRIC PROPORTION
8763HOMOTHETIC
8764TILDE OPERATOR
8765REVERSED TILDE
8766INVERTED LAZY S
8767SINE WAVE
8768WREATH PRODUCT
8769NOT TILDE
8770MINUS TILDE
8771ASYMPTOTICALLY EQUAL TO
8772NOT ASYMPTOTICALLY EQUAL TO
8773APPROXIMATELY EQUAL TO
8774APPROXIMATELY BUT NOT ACTUALLY EQUAL TO
8775NEITHER APPROXIMATELY NOR ACTUALLY EQUAL TO
8776ALMOST EQUAL TO
8777NOT ALMOST EQUAL TO
8778ALMOST EQUAL OR EQUAL TO
8779TRIPLE TILDE
8780ALL EQUAL TO
8781EQUIVALENT TO
8782GEOMETRICALLY EQUIVALENT TO
8783DIFFERENCE BETWEEN
8784APPROACHES THE LIMIT
8785GEOMETRICALLY EQUAL TO
8786APPROXIMATELY EQUAL TO OR THE IMAGE OF
8787IMAGE OF OR APPROXIMATELY EQUAL TO
8788COLON EQUALS
8789EQUALS COLON
8790RING IN EQUAL TO
8791RING EQUAL TO
8792CORRESPONDS TO
8793ESTIMATES
8794EQUIANGULAR TO
8795STAR EQUALS
8796DELTA EQUAL TO
8797EQUAL TO BY DEFINITION
8798MEASURED BY
8799QUESTIONED EQUAL TO
8800NOT EQUAL TO
8801IDENTICAL TO
8802NOT IDENTICAL TO
8803STRICTLY EQUIVALENT TO
8804LESS-THAN OR EQUAL TO
8805GREATER-THAN OR EQUAL TO
8806LESS-THAN OVER EQUAL TO
8807GREATER-THAN OVER EQUAL TO
8808LESS-THAN BUT NOT EQUAL TO
8809GREATER-THAN BUT NOT EQUAL TO
8810MUCH LESS-THAN
8811MUCH GREATER-THAN
8812BETWEEN
8813NOT EQUIVALENT TO
8814NOT LESS-THAN
8815NOT GREATER-THAN
8816NEITHER LESS-THAN NOR EQUAL TO
8817NEITHER GREATER-THAN NOR EQUAL TO
8818LESS-THAN OR EQUIVALENT TO
8819GREATER-THAN OR EQUIVALENT TO
8820NEITHER LESS-THAN NOR EQUIVALENT TO
8821NEITHER GREATER-THAN NOR EQUIVALENT TO
8822LESS-THAN OR GREATER-THAN
8823GREATER-THAN OR LESS-THAN
8824NEITHER LESS-THAN NOR GREATER-THAN
8825NEITHER GREATER-THAN NOR LESS-THAN
8826PRECEDES
8827SUCCEEDS
8828PRECEDES OR EQUAL TO
8829SUCCEEDS OR EQUAL TO
8830PRECEDES OR EQUIVALENT TO
8831SUCCEEDS OR EQUIVALENT TO
8832DOES NOT PRECEDE
8833DOES NOT SUCCEED
8834SUBSET OF
8835SUPERSET OF
8836NOT A SUBSET OF
8837NOT A SUPERSET OF
8838SUBSET OF OR EQUAL TO
8839SUPERSET OF OR EQUAL TO
8840NEITHER A SUBSET OF NOR EQUAL TO
8841NEITHER A SUPERSET OF NOR EQUAL TO
8842SUBSET OF WITH NOT EQUAL TO
8843SUPERSET OF WITH NOT EQUAL TO
8844MULTISET
8845MULTISET MULTIPLICATION
8846MULTISET UNION
8847SQUARE IMAGE OF
8848SQUARE ORIGINAL OF
8849SQUARE IMAGE OF OR EQUAL TO
8850SQUARE ORIGINAL OF OR EQUAL TO
8851SQUARE CAP
8852SQUARE CUP
8853CIRCLED PLUS
8854CIRCLED MINUS
8855CIRCLED TIMES
8856CIRCLED DIVISION SLASH
8857CIRCLED DOT OPERATOR
8858CIRCLED RING OPERATOR
8859CIRCLED ASTERISK OPERATOR
8860CIRCLED EQUALS
8861CIRCLED DASH
8862SQUARED PLUS
8863SQUARED MINUS
8864SQUARED TIMES
8865SQUARED DOT OPERATOR
8866RIGHT TACK
8867LEFT TACK
8868DOWN TACK
8869UP TACK
8870ASSERTION
8871MODELS
8872TRUE
8873FORCES
8874TRIPLE VERTICAL BAR RIGHT TURNSTILE
8875DOUBLE VERTICAL BAR DOUBLE RIGHT TURNSTILE
8876DOES NOT PROVE
8877NOT TRUE
8878DOES NOT FORCE
8879NEGATED DOUBLE VERTICAL BAR DOUBLE RIGHT TURNSTILE
8880PRECEDES UNDER RELATION
8881SUCCEEDS UNDER RELATION
8882NORMAL SUBGROUP OF
8883CONTAINS AS NORMAL SUBGROUP
8884NORMAL SUBGROUP OF OR EQUAL TO
8885CONTAINS AS NORMAL SUBGROUP OR EQUAL TO
8886ORIGINAL OF
8887IMAGE OF
8888MULTIMAP
8889HERMITIAN CONJUGATE MATRIX
8890INTERCALATE
8891XOR
8892NAND
8893NOR
8894RIGHT ANGLE WITH ARC
8895RIGHT TRIANGLE
8896N-ARY LOGICAL AND
8897N-ARY LOGICAL OR
8898N-ARY INTERSECTION
8899N-ARY UNION
8900DIAMOND OPERATOR
8901DOT OPERATOR
8902STAR OPERATOR
8903DIVISION TIMES
8904BOWTIE
8905LEFT NORMAL FACTOR SEMIDIRECT PRODUCT
8906RIGHT NORMAL FACTOR SEMIDIRECT PRODUCT
8907LEFT SEMIDIRECT PRODUCT
8908RIGHT SEMIDIRECT PRODUCT
8909REVERSED TILDE EQUALS
8910CURLY LOGICAL OR
8911CURLY LOGICAL AND
8912DOUBLE SUBSET
8913DOUBLE SUPERSET
8914DOUBLE INTERSECTION
8915DOUBLE UNION
8916PITCHFORK
8917EQUAL AND PARALLEL TO
8918LESS-THAN WITH DOT
8919GREATER-THAN WITH DOT
8920VERY MUCH LESS-THAN
8921VERY MUCH GREATER-THAN
8922LESS-THAN EQUAL TO OR GREATER-THAN
8923GREATER-THAN EQUAL TO OR LESS-THAN
8924EQUAL TO OR LESS-THAN
8925EQUAL TO OR GREATER-THAN
8926EQUAL TO OR PRECEDES
8927EQUAL TO OR SUCCEEDS
8928DOES NOT PRECEDE OR EQUAL
8929DOES NOT SUCCEED OR EQUAL
8930NOT SQUARE IMAGE OF OR EQUAL TO
8931NOT SQUARE ORIGINAL OF OR EQUAL TO
8932SQUARE IMAGE OF OR NOT EQUAL TO
8933SQUARE ORIGINAL OF OR NOT EQUAL TO
8934LESS-THAN BUT NOT EQUIVALENT TO
8935GREATER-THAN BUT NOT EQUIVALENT TO
8936PRECEDES BUT NOT EQUIVALENT TO
8937SUCCEEDS BUT NOT EQUIVALENT TO
8938NOT NORMAL SUBGROUP OF
8939DOES NOT CONTAIN AS NORMAL SUBGROUP
8940NOT NORMAL SUBGROUP OF OR EQUAL TO
8941DOES NOT CONTAIN AS NORMAL SUBGROUP OR EQUAL
8942VERTICAL ELLIPSIS
8943MIDLINE HORIZONTAL ELLIPSIS
8944UP RIGHT DIAGONAL ELLIPSIS
8945DOWN RIGHT DIAGONAL ELLIPSIS