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)

ALL CALCULATIONS BEGIN WITH =

OPERATORS
Multiplication *
Division /
Addition +
Subtraction

= Cell Ref Operator Cell Ref

Basic Formula.png

Order of Operations

When doing Formulas what is done first second third etc

BODMAS

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

Advertisements

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: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
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:

WordPress.com Logo

You are commenting using your WordPress.com 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