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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating 3d formulas

Creating 3d formulas

ResolvedVersion 2010

Wed 14 Dec 2011, 16:54 Delegate Germaine said...

Germaine has attended:
Excel Intermediate course

Creating 3d formulas

helpful hints to practice?

Tue 20 Dec 2011, 16:30 Trainer Andrew said...

RE: creating 3d formulas

Hi Germaine,

Thank you for your question - the main thing to ensure when working with 3D formulas is that the data in your sheets is laid out identically. In other words the values you want to total across the sheets are stored in the same respective cells, regardless of the sheet they are on

I hope this helps - do let me know if you have any further questions.

Kind regards,
Andrew

Tue 27 Dec 2011: Automatically marked as resolved.

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Creating 3d formulas

Creating 3d formulas

RE: creating 3d formulas

Excel articles

Excel tip:

Stop Formula Returning A "#DIV/0" Error