Friday, 23 January 2015

Formulas

FORMULAS?
faces animated GIF

A Misunderstanding folks!
Not THAT kind of formula, remember we are talking about Excel here?

The formula i'm saying is used to perform calculations in Excel.
Note: It always starts off with an equal (=) sign

Example:
=4*5 (will result to 20)
=B1+B2 (will result to sum of the values in selected cells)

Note: (+) for addition
(-) for subtraction
(*) for multiplication
(/) for division

A funny thing when we were discussing this topic is that there's this Operator in excel that we couldn't figure out how it's pronounced or even spelled...
the AMPERSAND (&)




No comments:

Post a Comment