Detailed instructions on excel-formula(s).

There are many formulas that you can choose from. They are divided up into 7 different categories and are on the FORMULAS tab in Excel. The categories are:

- Financial
- Logical
- Text
- Date & Time
- Lookup & Reference
- Math & trig
- More Functions

Then there are also sections for

- Recently used
- AutoSum

If you are not sure which one to use you can use the `Insert Function`

button to help with determining which one to use.

You do not have to use just one formula at a time, you can combine them to get the results that are needed or combine them with other things like `Named Ranges`

.

`Named Ranges`

are also on the FORMULAS tab in the *Define Name* section. You can use the *Name Manager* to create or modify the ranges and names of the ranges. There are also three other buttons there for *Define Name* to define and apply names, *Use in Formula* to choose a defined name and insert it into a formula, and *Create from Selection* which will create a named range with the name based on the top-left most cell in the range.

There is also the **Formula Auditing** section. This section will help in troubleshooting a formula. Here you can trace the formula and see what exactly it is doing.

Finally, there is the **Calculation** section which will allow you to turn on/off the automatic calculation of all formulas and to manually calculate any formulas whether auto-calculate is on or not.

if you want to reproduce, please indicate the source:

Getting started with excel-formula – Installation or Setup - CodeDay