Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Built-In Formulas and Functions

Excel has a variety of built-in functions that can be accessed using the Formula Wizard, click the link for instructions on how to use the Formula Wizard.

If the function you want is not shown when you click the drop-down arrow on the function list you can click the More functions option at the bottom to display a window giving you access to all Excel’s built-in functions as shown below.

 

You can either choose All from the list on the left to show all the built-in functions on the right (scroll down to find the one you want) or you can choose a category that may contain the function and look for it in there.  When you have chosen a function and click OK the function wizard will proceed to help you complete the arguments.
Built-in functions can be categorised as follows:
 

Function

Action

Mathematical/Trigonometric

Take a number as data, transform it, and produce a numerical result.  For example, sine and absolute value are math functions.

Logical

Consider a condition and return True or False

Text

Manipulate or create strings

Date/Time

Perform calculations on dates, times, and combinations of dates and times

Statistical

Return statistical values to sets of numbers.  For example, average, count, min, max, etc.

Database

Same as statistical, however datasets are taken from a database

Financial

Helpful when calculating such things as interest, monthly payments, and assist in what-if scenarios

Information

Used to get information about the contents of a cell

Lookup/Reference

Manipulate or examine areas of a worksheet

Click here to return to the Excel index.

webmaster@allaboutoffice.co.uk