Functions
- Excel Tips
- Excel Cell References
- Cell Addressing
- Text and Values in One Cell
- How To Use Excel IF Function
- Functions
- How to Determine whether VBA is Enabled
- Adjusting formulas to your Regional Settings
- Excel AND Function
- Excel Date and Time Format
- English
- Switch per la lingua italiana
There are a wide range of functions available for calculations, to enter one use the Function choice from the Insert menu option or click on the = button in the edit line.
(In v7 click on the function
button Which starts up the Function Wizard which is an aid to correctly entering the required function. Functions are grouped by category. )
Choose the one you want and then click on the [Next] button, following the instructions in the next window.
Ranges of cells
An example of using formulae and functions

Assume you have a list of people and marks in columns A and B and a pass mark stored in cell B2. You wish to automatically enter in column C whether or not the person has passed

Select the Function Category and then the function required. Press [OK]

Fill in the blanks and press [OK]

Extend the formula down to cover the other cells.

a pig in a poke
of the software in PDF
like you
of MarketFeeder Pro

