MY CARTHow to Create 3D Formulas in Microsoft Excel 2010: Video
This video shows you how to create 3D formulas in Microsoft Excel 2010 and the additional punctuation marks and syntax you need to write them. Get the complete Excel tutorial here
3D Formulas in Microsoft Excel 2010: Overview
It is helpful to be able to create a single formula that calculates data gathered from multiple worksheets. These types of formulas are called 3D formulas. They calculate information from multiple worksheets and show the result in a selected formula cell.
When you use 3D formulas, you must also expand your knowledge of formula syntax. You will be using additional punctuation marks when you write these formulas in order to tell Excel specifically which cells from which worksheet you will be using. The additional punctuation marks you will need to know are:
1. !- used to separate the sheet name from the cell reference.
2. $- used to denote an absolute value.
3. :- used to separate sheet names in ranged 3D formulas.
4. ,- used to separate individual sheet/cell references from each other.
