Excel has lots of possibilities to make complicated calculations with formulas, but the formulas can also be used to manage data better or to look for things. Excel divides the formulas into the following 7 categories:
- Financial: Calculates financial calculations such as interest, return, revenue, etc.
- Logical: Logical functions allow you to check whether things are correct or whether something is excluded or included. Examples: If (if a condition is met then the formula is executed or give value), where (You enter a value and if it satisfies you will get a true), etc.
- Text: Allows you to adjust texts. For example, Delete spaces (all spaces are erased), Length (indicates how long a text is in a cell), merge text (can merge texts from different cells into a cell), etc.
- Date / time: Date (convert the day you enter into Microsoft codes), minute (calculates day, year, month to minutes), days360 (calculates the number of days between 2 dates assuming 360 days in a year), etc .
- Search and reference: Horizontal search (looks for a specified value in the first row of table and returns the answer from the corresponding column), Transpose (changed vertically to horizontal), Vertical search (looks for a specified value in the leftmost column, and then outputs that row returns the corresponding answer), etc.
- Mathematics and trigonometry: Rounding off (around numbers), sum. (Counts on everything that meets criteria), root (calculates the root of a number), etc.
- Other functions: Below are more functions grouped to:
- Statistical: Below you will find useful formulas such as Number (counts number of cells with a value), but also more complicated static calculations as standard deviation.
- Technique: Below are formulas to calculate technical things.
- Cube: Does all kinds of cube calculations
- Information: Checks information for example: Is.even (or number is even), ISText (checks whether value is in cell text).
But how do you use the formula in Excel? Stand in the cell. Click on insert function in formulas tab. In the screen that opens you choose the formula you want to use. With each formula, Excel also indicates which condition it expects from you.