{"id":1966,"date":"2019-07-22T17:12:01","date_gmt":"2019-07-22T23:12:01","guid":{"rendered":"https:\/\/www.brendapenman.com\/?p=1966"},"modified":"2021-11-21T16:04:16","modified_gmt":"2021-11-21T23:04:16","slug":"excel_precedents","status":"publish","type":"post","link":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/","title":{"rendered":"In what Order, does Excel Calculate a Formula?"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”3.25.2″ 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.27.4″ global_colors_info=”{}”]<\/p>\n

When you create a formula that contains several operators, Excel performs the calculation in a specific order.\u00a0 For example,\u00a0 Excel always performs multiplication before addition.\u00a0 This order is called Operator Precedence.<\/strong><\/p>\n

You can use parenthesis ()<\/strong> to override the Operator Precedence and specify with operation to perform first.\u00a0<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25.2″ custom_margin=”-38px|auto||auto||” 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.27.4″ global_colors_info=”{}”]<\/p>\n

Microsoft Excel always calculates the portion of the formula in parenthesis ()<\/strong> before using the precedence rules below.<\/p>\n

Note:<\/strong> The Order column identifies the Operator Precedence. #1 is calculated first, followed by #2.\u00a0 #8, the comparison operators are always calculated last.<\/p>\n

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

E.g.<\/strong><\/p>\n

#5 multiplication and division are always calculated before #6 addition and subtraction.<\/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″ custom_margin=”||0px” custom_padding=”||0px” 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.27.4″ global_colors_info=”{}”]<\/p>\n

The Order of Operator Precedence<\/h2>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_2″ 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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”||||||||” header_font=”||||||||” global_colors_info=”{}”]<\/p>\n

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

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

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

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

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

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_2″ _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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|800|||||||” text_text_color=”#117ab6″ custom_margin=”||0px” custom_padding=”||0px” text_text_shadow_style=”preset5″ global_colors_info=”{}”][\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ 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=”1_2″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ 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_4,1_4,1_2″ 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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|800|||||||” text_text_color=”#117ab6″ custom_margin=”||0px” custom_padding=”||0px” text_text_shadow_style=”preset5″ global_colors_info=”{}”]<\/p>\n

1<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”][\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

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

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

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

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

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

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

Reference Operators<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_2″ _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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|800|||||||” text_text_color=”#117ab6″ custom_margin=”||0px” custom_padding=”||0px” text_text_shadow_style=”preset5″ global_colors_info=”{}”]<\/p>\n

2<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

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

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

Minus (for negative numbers)<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_2″ _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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|800|||||||” text_text_color=”#117ab6″ custom_margin=”||0px” custom_padding=”||0px” text_text_shadow_style=”preset5″ global_colors_info=”{}”]<\/p>\n

3<\/p>\n

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

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

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

Percent<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_2″ _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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|800|||||||” text_text_color=”#117ab6″ custom_margin=”||0px” custom_padding=”||0px” text_text_shadow_style=”preset5″ global_colors_info=”{}”]<\/p>\n

4<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

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

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ 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_4,1_4,1_2″ _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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|800|||||||” text_text_color=”#117ab6″ custom_margin=”||0px” custom_padding=”||0px” text_text_shadow_style=”preset5″ global_colors_info=”{}”]<\/p>\n

5<\/p>\n

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

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

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

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

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

Multiplication<\/p>\n

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

Division<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_2″ _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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|800|||||||” text_text_color=”#117ab6″ custom_margin=”||0px” custom_padding=”||0px” text_text_shadow_style=”preset5″ global_colors_info=”{}”]<\/p>\n

6<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”||||||||” custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

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

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

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

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

Addition<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ 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_4,1_4,1_2″ _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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|800|||||||” text_text_color=”#117ab6″ custom_margin=”||0px” custom_padding=”||0px” text_text_shadow_style=”preset5″ global_colors_info=”{}”]<\/p>\n

7<\/p>\n

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

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

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ 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_4,1_4,1_2″ _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_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|800|||||||” text_text_color=”#117ab6″ custom_margin=”||0px” custom_padding=”||0px” text_text_shadow_style=”preset5″ global_colors_info=”{}”]<\/p>\n

8<\/p>\n

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

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

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

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

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

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

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

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

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

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

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

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

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

Equal to<\/p>\n

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

Greater than<\/p>\n

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

Less than<\/p>\n

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

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

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

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

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

Not equal to<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”ExampleSection” _builder_version=”3.25.2″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”||0px” 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.27.4″ global_colors_info=”{}”]<\/p>\n

Let’s Try a Few Examples…<\/h2>\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 _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

As you will notice, depending upon how your formulas are constructed, Excel may provide a different answer than you were expecting.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25.2″ custom_margin=”||0px” custom_padding=”||0px” border_width_bottom=”1px” border_color_bottom=”#c5c5c5″ border_style_bottom=”inset” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|0px||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

2 + 3 * 4<\/p>\n

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

In this formula, there are no parenthesis, so Excel calculates the formula based on the order of Operator Precedence:<\/p>\n

3 * 4 which equals 12<\/p>\n

then\u00a0 2 + 12<\/p>\n

Answer: 14<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|0px||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

(2 + 3) * 4<\/p>\n

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

Excel calculates the parenthesis () first:<\/p>\n

2 + 3 which equals 5<\/p>\n

then\u00a0 5 * 4<\/p>\n

Answer: 20<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25.2″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25.2″ global_colors_info=”{}”][et_pb_divider divider_style=”ridge” divider_weight=”3px” _builder_version=”3.25.2″ global_colors_info=”{}”][\/et_pb_divider][\/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 _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

More complex formulas may also be constructed by using nested parethesis. Excel always calculates the values in the innermost parenthesis () first.<\/p>\n

Note:<\/strong> If your formula does not have a matching right parenthesis, Excel will add one for you.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”3.25″ custom_padding=”|0px||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ custom_padding=”||0px|||” global_colors_info=”{}”]<\/p>\n

=(<\/span>(<\/span><\/strong>2*2)<\/span><\/strong>+(<\/strong><\/span>4*4)<\/strong><\/span>+(<\/span><\/strong>5*5)<\/span>)<\/span><\/strong>*2<\/p>\n

=(<\/span>(<\/span><\/strong>4)<\/span><\/strong>+(<\/span><\/strong>16)<\/span><\/strong>+(<\/span><\/strong>25)<\/span>)<\/span><\/strong>*2<\/p>\n

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

Here Excel calculates the innermost parenthesis () first, from left to right.<\/p>\n

(<\/strong><\/span>2*2)<\/strong><\/span>=4<\/p>\n

(<\/strong><\/span>4*4)<\/strong><\/span>=16<\/p>\n

(<\/span><\/strong>5*5)<\/strong><\/span>=25<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ _builder_version=”3.25.2″ custom_margin=”||0px” custom_padding=”||0px” border_style_all=”outset” border_width_bottom=”1px” border_color_bottom=”#c5c5c5″ border_style_bottom=”inset” global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”3.25″ custom_padding=”|0px||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

=(<\/span><\/strong>4+16+25<\/span>)<\/span><\/strong>*2<\/span><\/p>\n

=45*2<\/p>\n

=90<\/span><\/p>\n

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

After Excel calculates the innermost parenthesis, your formula looks like this.<\/p>\n

Then Excel calculates the next set of parenthesis ()<\/span><\/strong>.<\/p>\n

Then Excel evaluates the rest of the formula based on the order of precedence because there are no more parenthesis.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ _builder_version=”3.25.2″ custom_margin=”||0px” custom_padding=”||0px” border_width_bottom=”1px” border_color_bottom=”#c5c5c5″ border_style_bottom=”inset” global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”3.25″ custom_padding=”|0px||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ custom_padding=”||0px|||” global_colors_info=”{}”]<\/p>\n

=(<\/span><\/strong>2+3)<\/strong><\/span>*5-(<\/span><\/strong>4+6)<\/span><\/strong>*2<\/p>\n

=(<\/span>5<\/span>)<\/strong><\/span>*5-(<\/span><\/strong>10<\/span>)<\/span><\/strong>*2<\/p>\n

=25-20<\/p>\n

=5<\/p>\n

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

Here Excel calculates the parenthesis () first, from left to right.<\/p>\n

Then Excel evaluates the rest of the formula based on the order of precedence, from left to right.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”3.25″ custom_padding=”|0px||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ custom_padding=”||0px|||” global_colors_info=”{}”]<\/p>\n

=(<\/span><\/strong>2+3)<\/span><\/strong>*1.05<\/p>\n

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

Here Excel calculates the parenthesis ()<\/span><\/strong> first.<\/p>\n

Then Excel evaluates the rest of the formula.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_divider color=”#cccccc” divider_style=”outset” divider_weight=”1px” _builder_version=”3.24.1″ custom_margin=”0px||0px” custom_padding=”0px||0px” border_color_all=”#117ab6″ global_colors_info=”{}”][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”||0px” collapsed=”on” global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”3.25″ custom_padding=”|0px||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ custom_margin=”|0px||” custom_padding=”|0px|0px|||” global_colors_info=”{}”]<\/p>\n

=(<\/span><\/strong>3-(<\/span><\/strong>6*8+2-(<\/strong><\/span>7-5)<\/span><\/strong>+3)<\/strong><\/span>\/2)<\/strong><\/span>*4<\/p>\n

=(<\/span><\/strong>3-(<\/span><\/strong>6*8+2-(<\/strong><\/span>2)<\/span><\/strong>+3)<\/strong><\/span>\/2)<\/strong><\/span>*4<\/p>\n

=(<\/span><\/strong>3-(<\/span><\/strong>48+2-(<\/strong><\/span>2)<\/span><\/strong>+3)<\/strong><\/span>\/2)<\/strong><\/span>*4<\/p>\n

=(<\/span><\/strong>3-(51<\/span><\/span>)<\/strong><\/span>\/2)<\/strong><\/span>*4<\/p>\n

=(<\/span><\/strong>3-25.5)<\/strong><\/span>*4<\/p>\n

=(–<\/span><\/span><\/strong>22.5)<\/strong><\/span>*4<\/p>\n

=-90<\/p>\n

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

Here Excel calculates the innermost nested parenthesis ()<\/strong><\/span> first and subtracts 5 from 7.<\/p>\n

Then Excel looks at the next nested outer parenthesis ()<\/strong><\/span>. Within that set of parenthesis, it uses the order of precedence and multliples 6 by 8 first. Then it adds or substracts the remaining numbers with the parenthesis ()<\/strong><\/span>.<\/p>\n

Then Excel looks at the next outer parenthesis ()<\/strong><\/span>. Within that set of parenthesis it uses the order of precedence and divides 51 by 2 first. Then it subracts 25.5 from 3.<\/p>\n

Then Excel evaluates the rest of the formula.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Closing Comments” _builder_version=”3.27.2″ custom_padding=”||0px||false|false” 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 _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Please share this tip with other Excel users to ensure that Excel performs the calculations correctly.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ text_text_color=”#00a4e4″ text_font_size=”22px” text_orientation=”center” custom_margin=”0px||0px” custom_padding=”0px||0px” text_text_align=”center” global_colors_info=”{}”]<\/p>\n

~ Let Microsoft Excel do the work for you. ~<\/strong><\/em><\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Submit a Commet” _builder_version=”3.25.2″ custom_margin=”0px||” custom_padding=”0px|20px||20px” 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_comments show_count=”off” _builder_version=”4.13.0″ form_field_background_color=”#ffffff” form_field_text_color=”#333333″ header_font=”Montserrat||||||||” body_font=”||||||||” form_field_font=”||||||||” form_field_text_align=”left” custom_button=”on” button_text_color=”#ffffff” button_bg_color=”#00A4E4″ button_border_color=”#00A4E4″ button_font=”Montserrat|600|||||||” button_icon=”E||divi||400″ button_icon_color=”#ffffff” button_alignment=”right” custom_margin=”0px||0px” custom_padding=”0px|0px|0px|0px” border_width_all_fields=”1px” border_color_all_fields=”#dbdbdb” border_style_all_fields=”ridge” box_shadow_style_fields=”preset3″ box_shadow_style_button=”preset2″ global_colors_info=”{}”][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

When you create a formula that contains several operators, Microsoft Excel performs the calculation in a specific order. This order is called Operator Precedence. Discover the Order of Operator Precedence and how to setup your formulas so that Excel performs the calculations correctly […]<\/p>\n","protected":false},"author":1,"featured_media":2274,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[2],"tags":[56,12,36,25,24,52,51,55,50,32,35,33,34,68,54,57,53],"class_list":["post-1966","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","tag-calculation-order","tag-excel","tag-excel-2013","tag-excel-2016","tag-excel-2019","tag-excel-calculations","tag-excel-formulas","tag-formula-order","tag-formulas","tag-microsoft-excel","tag-microsoft-excel-2013","tag-microsoft-excel-2016","tag-microsoft-excel-2019","tag-operator-precedence","tag-order-of-operator-precedence","tag-precedence","tag-precedents"],"yoast_head":"\nIn what Order, does Excel Calculate a Formula? - Brenda Penman<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"In what Order, does Excel Calculate a Formula? - Brenda Penman\" \/>\n<meta property=\"og:description\" content=\"When you create a formula that contains several operators, Microsoft Excel performs the calculation in a specific order. This order is called Operator Precedence. Discover the Order of Operator Precedence and how to setup your formulas so that Excel performs the calculations correctly [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/\" \/>\n<meta property=\"og:site_name\" content=\"Brenda Penman\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-22T23:12:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-21T23:04:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/ExcelOperatorPrecedence2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"717\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brenda Penman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brenda Penman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/\"},\"author\":{\"name\":\"Brenda Penman\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"headline\":\"In what Order, does Excel Calculate a Formula?\",\"datePublished\":\"2019-07-22T23:12:01+00:00\",\"dateModified\":\"2021-11-21T23:04:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/\"},\"wordCount\":3658,\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/ExcelOperatorPrecedence2.png\",\"keywords\":[\"Calculation Order\",\"Excel\",\"Excel 2013\",\"Excel 2016\",\"Excel 2019\",\"Excel Calculations\",\"Excel Formulas\",\"Formula Order\",\"Formulas\",\"Microsoft Excel\",\"Microsoft Excel 2013\",\"Microsoft Excel 2016\",\"Microsoft Excel 2019\",\"Operator Precedence\",\"Order of Operator Precedence\",\"Precedence\",\"Precedents\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/\",\"name\":\"In what Order, does Excel Calculate a Formula? - Brenda Penman\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/ExcelOperatorPrecedence2.png\",\"datePublished\":\"2019-07-22T23:12:01+00:00\",\"dateModified\":\"2021-11-21T23:04:16+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/ExcelOperatorPrecedence2.png\",\"contentUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/ExcelOperatorPrecedence2.png\",\"width\":1080,\"height\":717,\"caption\":\"The Order of Operator Precedence in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_precedents\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"In what Order, does Excel Calculate a Formula?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\",\"name\":\"Brenda Penman\",\"description\":\"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\",\"name\":\"Brenda Penman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"caption\":\"Brenda Penman\"},\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/author\\\/mfvwwyzbgoqzie\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"In what Order, does Excel Calculate a Formula? - Brenda Penman","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/","og_locale":"en_US","og_type":"article","og_title":"In what Order, does Excel Calculate a Formula? - Brenda Penman","og_description":"When you create a formula that contains several operators, Microsoft Excel performs the calculation in a specific order. This order is called Operator Precedence. Discover the Order of Operator Precedence and how to setup your formulas so that Excel performs the calculations correctly [...]","og_url":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/","og_site_name":"Brenda Penman","article_published_time":"2019-07-22T23:12:01+00:00","article_modified_time":"2021-11-21T23:04:16+00:00","og_image":[{"width":1080,"height":717,"url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/ExcelOperatorPrecedence2.png","type":"image\/png"}],"author":"Brenda Penman","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Brenda Penman","Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/#article","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/"},"author":{"name":"Brenda Penman","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"headline":"In what Order, does Excel Calculate a Formula?","datePublished":"2019-07-22T23:12:01+00:00","dateModified":"2021-11-21T23:04:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/"},"wordCount":3658,"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/ExcelOperatorPrecedence2.png","keywords":["Calculation Order","Excel","Excel 2013","Excel 2016","Excel 2019","Excel Calculations","Excel Formulas","Formula Order","Formulas","Microsoft Excel","Microsoft Excel 2013","Microsoft Excel 2016","Microsoft Excel 2019","Operator Precedence","Order of Operator Precedence","Precedence","Precedents"],"articleSection":["Microsoft Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/","url":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/","name":"In what Order, does Excel Calculate a Formula? - Brenda Penman","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/#primaryimage"},"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/ExcelOperatorPrecedence2.png","datePublished":"2019-07-22T23:12:01+00:00","dateModified":"2021-11-21T23:04:16+00:00","author":{"@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"breadcrumb":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.brendapenman.com\/blog\/excel_precedents\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/#primaryimage","url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/ExcelOperatorPrecedence2.png","contentUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2019\/06\/ExcelOperatorPrecedence2.png","width":1080,"height":717,"caption":"The Order of Operator Precedence in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.brendapenman.com\/blog\/excel_precedents\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.brendapenman.com\/blog\/"},{"@type":"ListItem","position":2,"name":"In what Order, does Excel Calculate a Formula?"}]},{"@type":"WebSite","@id":"https:\/\/www.brendapenman.com\/blog\/#website","url":"https:\/\/www.brendapenman.com\/blog\/","name":"Brenda Penman","description":"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.brendapenman.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef","name":"Brenda Penman","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","caption":"Brenda Penman"},"url":"https:\/\/www.brendapenman.com\/blog\/author\/mfvwwyzbgoqzie\/"}]}},"_links":{"self":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/1966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/comments?post=1966"}],"version-history":[{"count":5,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/1966\/revisions"}],"predecessor-version":[{"id":3511,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/1966\/revisions\/3511"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media\/2274"}],"wp:attachment":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media?parent=1966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/categories?post=1966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/tags?post=1966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}