Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel consulting - d formula

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consulting - 3d formula

excel consulting - 3d formula

ResolvedVersion Standard

Rosanna has attended:
Excel Intermediate course
Excel Intermediate course

3d formula

gow do I create a 3d formula

RE: 3d formula

Hi Rosanna,

Thanks for the question.

3D formulas are where you can use the data or formulas from different tabs in different sheets and also different workbooks.

When you look at your formulas Sheets are shown with a ! for example North becomes North! and worksheets are in square brackets.

Hope that helps

Tracy

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.