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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s