Advanced Formula Environment

Writing Excel formulas with the help of Name Manager can be a demanding job. When you write simple formulas, you will still somehow manage. With complex formulas or changing existing ones, there is a high chance that you will make a mistake. The LAMBDA feature allows you to create your own functions as names added in the Name Manager, and to make this job easier, Microsoft has created an Excel add-in for creating complex formulas: Advanced Formula Environment.

Trigonometric functions

If you are someone who likes mathematics it will be useful for you to know that Excel has a lot of trigonometric functions, and we can use them whenever is necessary to plot your sinusoids. These are the functions of SIN (sine), COS (cosine), TAN (tangent), COT (cotangent), and there are many others as well. If you are curious you can easily find them in the Excel function library. How to draw a sinusoid?

Let’s calculate

Besides basic calculating operators like addition (+), subtraction (-), multiplication (*), and division (/) Excel contains even a handful of functions that we can use to perform various mathematical operations. Also, there are functions for calculating the absolute value, returning the number sign, and some other functions that can be of importance, for example, to create conditions in conditional formatting, when we want to color each different order in different colors …