Formuals and Functions

Hi Deorne

Thanks for clarifying.

The fx button is referred to as the Insert Function button.

It's purpose is to allow you to search for and insert functions into a spreadsheet.

If you select the cell where you want the function to go in your spreadsheet, then click the Insert Function button, you will then be able to search for a function (e.g. IF function).

Then you select the function you wish to use from the options presented, and click OK.

At the following screen, you will be presented with the parts of the function (called arguments) that you need to enter into the function in order to obtain a result. Some functions have more arguments than others. Once you have filled in all the arguments, then click OK and if Excel can figure out a result for you based on the arguments you have entered, then this will display in the spreadsheet.

Kind regards
Amanda