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 =
= Cell Ref Operator Cell Ref
Order of Operations
When doing Formulas what is done first second third etc
B ( )
Exponential eg 3m2
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