Using Math Functions In Excel Knowledgebase

Quantunet.com

Excel QuickSkills

Using Math Functions In Excel

Mathematics Functions In Excel

SUM

ABS

MOD

ROUND

ROUNDUP

SUMPRODUCT

SUBTOTAL
TRUNC

There is quite a comprehensive list of mathematics functions available in excel. To view the list of functions go to:

Insert

Functions

Mathematics

The use of mathematics in excel is fundamental. Mathematics was an integral part of the original concept of the electronic spread sheet ...

Using the "AVERAGE" Function

Method 1 Inserting the function and editing it in the equation bar

Method 2 Writing the function into the equation bar by hand

if statements

boolean logic

equation solver

array formulas