How do I make mathematical equations in Excel?

Excel uses Operators in its formulas. These Operators are symbols that represent the mathematical (or logical) operations.

Operators Used in Excel Formulas

Here is a list of the Operators used in Excel formulas:

Operator

Description

+

Addition

Subtraction

*

Multiplication

/

Division or fractions

^

Exponents

( )

Overrides the order of mathematical operators

Unary minus (for negative numbers)

&

Joining text (concatenation)

>

Greater than

<

Less than

> =

Greater than or equal to

< =

Less than or equal to

< >

Not equal to

=

Equal to

,

Union operator as in SUM(A1,B2)

:

Range operator as in SUM(A1:A6)

<space>

Intersection operator as in SUM(A:D 2:4)

Formula Tips

*

Every formula always begins with an equal sign (=). This initial equal sign allows Excel to distinguish between a formula and text. 

The equal sign directs Excel to calculate an answer.

e.g.

=B5+B6

=B2*C9

*

No spaces in your formulas.

Exception: Only use a space when using Excel’s Intersect Operator

Order of Operator Precedence

When you create a formula that contains several operators, Excel performs the calculation in a specific order.

For example, Excel always performs multiplication before addition.

This order is called Operator Precedence.

For more information on Operator Precedence, refer to my article

Get your handout of

Operators Used In Excel Formulas

* Refer to this handout when creating your Excel formulas

Please share this chart with other Excel users.

~ Let Microsoft Excel do the work for you. ~

 

0 Comments

Pin It on Pinterest

Share This