{"id":3044,"date":"2019-09-25T14:00:18","date_gmt":"2019-09-25T20:00:18","guid":{"rendered":"https:\/\/www.brendapenman.com\/blog\/?p=3044"},"modified":"2021-11-21T15:43:09","modified_gmt":"2021-11-21T22:43:09","slug":"excel_operators","status":"publish","type":"post","link":"https:\/\/www.brendapenman.com\/blog\/excel_operators\/","title":{"rendered":"Mathematical Operators Used in Excel Formulas"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”3.24″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ collapsed=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

How do I make mathematical equations in Excel?<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

Excel uses Operators in its formulas. These Operators are symbols that represent the mathematical (or logical) operations.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text admin_label=”Header for Table” _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

Operators Used in Excel Formulas<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

Here is a list of the Operators used in Excel formulas:<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”3ColumnTable” _builder_version=”3.25.2″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_row column_structure=”1_3,2_3″ admin_label=”3ColumnTableHeader” _builder_version=”3.25.2″ use_background_color_gradient=”on” background_color_gradient_start=”#117AB6″ background_color_gradient_end=”#000000″ background_color_gradient_start_position=”17%” collapsed=”on” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” header_font=”||||||||” global_colors_info=”{}”]<\/p>\n

Operator<\/span><\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

Description<\/strong><\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”on” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

+<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25.2″ global_colors_info=”{}”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px|||” global_colors_info=”{}”]<\/p>\n

Addition<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ disabled_on=”off|off|off” _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

–<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Subtraction<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”on” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

*<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25.2″ global_colors_info=”{}”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px|||” global_colors_info=”{}”]<\/p>\n

Multiplication<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ disabled_on=”off|off|off” _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

\/<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Division or fractions<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

^<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Exponents<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ disabled_on=”off|off|off” _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

( )<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Overrides the order of mathematical operators<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

–<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Unary minus (for negative numbers)<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

&<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Joining text (concatenation)<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

><\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Greater than<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

<<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Less than<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

> =<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px|2px||” global_colors_info=”{}”]<\/p>\n

Greater than or equal to<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

< =<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Less than or equal to<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

< ><\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px|2px||” global_colors_info=”{}”]<\/p>\n

Not equal to<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

=<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Equal to<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

,<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px|2px||” global_colors_info=”{}”]<\/p>\n

Union operator as in SUM(A1,B2)<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”10px||0px” border_width_right=”1px” border_color_right=”rgba(0,0,0,0.18)” border_style_right=”outset” border_width_left=”1px” border_color_left=”rgba(0,0,0,0.18)” border_style_left=”outset” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

:<\/b><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

Range operator as in SUM(A1:A6)<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,2_3″ _builder_version=”3.25″ background_color=”#f5f5f5″ custom_margin=”||0px” custom_padding=”10px||0px” box_shadow_style=”preset6″ box_shadow_blur=”3px” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

<space><\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ custom_margin=”||0px” custom_padding=”||0px|2px||” global_colors_info=”{}”]<\/p>\n

Intersection operator as in SUM(A:D 2:4)<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”3ColumnTable” _builder_version=”3.25.2″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text admin_label=”Header for Table” _builder_version=”3.29.2″ header_font=”||||||||” header_line_height=”1.9em” header_3_font=”||||||||” header_3_text_color=”#00a4e4″ header_3_font_size=”23px” header_3_line_height=”1.6em” custom_margin=”||||false|false” custom_padding=”||||false|false” global_colors_info=”{}”]<\/p>\n

Formula Tips<\/h3>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ module_alignment=”left” custom_margin=”|||” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

*<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

Every formula always begins with an equal sign (=). This initial equal sign allows Excel to distinguish between a formula and text.\u00a0<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

The equal sign directs Excel to calculate an answer.<\/span><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.2″ custom_padding=”||0px|||” global_colors_info=”{}”]<\/p>\n

e.g.<\/p>\n

=B5+B6<\/p>\n

=B2*C9<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ module_alignment=”left” custom_margin=”|||” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.2″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

*<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

No spaces in your formulas.<\/p>\n

Exception:<\/strong> Only use a space when using Excel’s Intersect Operator<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”3ColumnTable” _builder_version=”3.25.2″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text admin_label=”Header for Table” _builder_version=”3.29.2″ header_font=”||||||||” header_line_height=”1.9em” header_3_font=”||||||||” header_3_text_color=”#00a4e4″ header_3_font_size=”23px” header_3_line_height=”1.6em” custom_margin=”||||false|false” custom_padding=”|||0px|false|false” global_colors_info=”{}”]<\/p>\n

Order of Operator Precedence<\/h3>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

When you create a formula that contains several operators, Excel performs the calculation in a specific order.<\/p>\n

For example, Excel always performs multiplication before addition.<\/p>\n

This order is called Operator Precedence<\/strong>.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

For more information on Operator Precedence, refer to my article<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.2″ text_font=”||||on||||” text_font_size=”21px” link_font=”|600|||on|||#117ab6|” custom_padding=”||35px|60px|false|false” global_colors_info=”{}”]<\/p>\n

In what Order, does Excel Calculate a Formula?<\/a><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.27.4″ top_divider_style=”slant2″ top_divider_color=”#4f008c” top_divider_height=”63px” bottom_divider_style=”slant2″ bottom_divider_color=”#4f008c” bottom_divider_height=”63px” border_width_all=”1px” border_color_all=”#bbbbbb” box_shadow_style=”preset1″ global_colors_info=”{}”][et_pb_row _builder_version=”3.27.4″ custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.27.4″ global_colors_info=”{}”][et_pb_text admin_label=”Header for Table” _builder_version=”3.29.2″ header_2_text_align=”center” header_3_text_color=”#000000″ text_orientation=”center” global_colors_info=”{}”]<\/p>\n

Get your handout of<\/h3>\n

[\/et_pb_text][et_pb_text admin_label=”Header for Table” _builder_version=”3.29.2″ header_2_text_align=”center” header_2_text_color=”#00a4e4″ global_colors_info=”{}”]<\/p>\n

Operators Used In Excel Formulas<\/h2>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”3.27.4″ custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column type=”1_2″ _builder_version=”3.27.4″ global_colors_info=”{}”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/MathematicalOperators1.png” _builder_version=”3.29.2″ custom_padding=”|||20px|false|false” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”3.27.4″ global_colors_info=”{}”][et_pb_code _builder_version=”3.29.2″ global_colors_info=”{}”]<\/p>\n

<\/div>\n