Excel performs calculations in a spreadsheet but it is also possible to perform calculations across multiple worksheets, this is called 3-dimensional (3D) functions. A 3D formula simplifies your writing Say you have a workbook that contains one sheet per month. You want to create a worksheet that will synthesize all these month in a worksheet …
Tag Archive: Cell reference
Articles sur le thème : Cell reference
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 = …
Permanent link to this article: https://www.excel-exercise.com/basic-calculation/
Absolute Relative References
What is a reference? The cell reference is the code that identify a cell: A1, B3, C15, … BJ375. But in Excel, there is absolute, relative and mixed references (but what-is-this-stuff 😲🤔🤨) It is very important to understand this concept to build your formulas to avoid mistakes. Relative reference A relative reference is a reference that will …
Permanent link to this article: https://www.excel-exercise.com/absolute-relative/
Use the Cell Value in your Calculation
In Excel, it’s very easy to use the value of a cell in your calculation. You just have to call the cell reference. What is the cell reference? In Excel, a cell is often called by it’s reference. In other words, the intersection of a row and a column, like A1, B5, D8,… Reusing the …
Permanent link to this article: https://www.excel-exercise.com/use-the-value-of-a-cell-in-excel/
Mixed References
Mixed reference A mixed reference is a reference that is fixed only on part of the reference: either the row or the column Before showing you an example of a calculation using mixed references, we will detail the use of the $ symbol in a reference. An absolute reference has two $. There is one …
Permanent link to this article: https://www.excel-exercise.com/mixed-reference/
Formulas to include or exclude tax
What is VAT? VAT (Value Added Tax) is a tax that is often added to goods or services. Each country or state defines it’s own VAT rates (in percent). For companies it is important to separate the price including and excluding VAT. Basic calculations in Excel If you have some problems with percentage calculations, have …
Permanent link to this article: https://www.excel-exercise.com/the-formulas-to-include-or-exclude-tax/