Tag Archive: Cell reference

Articles sur le thème : Cell reference

3D Function

Principe of a 3D formula

In Excel, you can build formula by making a relationship through many worksheet. This technique of writing is called 3D function

Permanent link to this article: https://www.excel-exercise.com/3d/

Basic calculation

Excel allows you to do all kinds of calculations and respect mathematical rules. We will see how to perform simple calculations (addition, subtraction, multiplication, division) and also how to perform operations that use several different operators without making any mistakes 😉 The = sign In Excel, all the calculations or formulas start with the = …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/basic-calculation/

Absolute Relative Reference – Dollar in Formula

Reference of cell with Dollars

In Excel, the reference of a cell could be relative or absolute (written with dollars). When you fixed a reference you can build professional dashboards

Permanent link to this article: https://www.excel-exercise.com/absolute-relative-reference-dollar-in-formula/

Use the Cell Value in your Calculation

Relative references, no dollar here

In Excel, it’s very easy to use the value of a cell. You just have to pointed to the reference of this cell and you return its value.

Permanent link to this article: https://www.excel-exercise.com/use-the-value-of-a-cell-in-excel/

Mixed References

Formula with mixed reference

A mixed reference is a reference that is fixed only on part of the reference

Permanent link to this article: https://www.excel-exercise.com/mixed-reference/

Formulas to include or exclude tax

Formula to add the tax directly to the price

Discover all the calculations to add taxes to a price or also to remove the tax from a price.

Permanent link to this article: https://www.excel-exercise.com/the-formulas-to-include-or-exclude-tax/