introduction excel training - Formulae

Hi Arabella

There are many different Excel functions that you can use, depending on what you are wanting to achieve.

I find that the best way to learn about various functions and what they can do is to look up worksheet functions in Help and then select Worksheet functions listed by category and browse through the function categories.

You can use more than one function as part of the same formula, again, it depends on what you are wanting to achieve. For example, you could use logical functions (AND, OR) in conjunction with the IF function to expand on how many criteria have to be met in order for Excel to decide to display the 'value if true' or 'value if false' result.

Thank you for your question.
Amanda