How to create basic formulas in Excel

How to create a basic formula

Formulas are when using + – * / symbols like on a calculator.

Functions are more structured and have over 270 functions pre-defined ie = sum (A1:A12)


Multiplication *
Division /
Addition +

= Cell Ref Operator Cell Ref

Basic Formula.png

Order of Operations

When doing Formulas what is done first second third etc


B ( )

Exponential eg 3m2

D /

M *

A +

S –

Eg; 5+ 2 * 10 = 25

If you need 70 to be your answer

Add brackets to the formula

(5+2)*10 = 70

Offering Customized Computer Training Courses, we come to you.

Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews

Related Topics

How to create a basic formula – YouTube

Vlookup not working?

Hide formula

Share Excel Files

Excel Course


About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s