Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macro

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Macro

Resolved · Low Priority · Version 2003

Reply Tue 6 Oct 2009, 16:21Delegate Bruce said...

Bruce has attended:
Excel Advanced course

Macro

Setting Up Standard Macro Headers

For upcoming training course dates see: Pricing & availability

Reply Wed 7 Oct 2009, 16:24Trainer Simon said...

RE: Macro

Hi Bruce,

Thank you for your question.

Can you please clarify your question in more detail.

Regards

Simon

Reply Thu 19 Nov 2009, 09:48 Edited on Tue 20 Mar 2012, 15:59Trainer Rich said...

RE: Macro

Hi Bruce

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

Wed 25 Nov 2009: Automatically marked as resolved.

Excel articles

· Fun Things I've Done With Excel
· Make Things Easier In Excel With Lists
· Crazy Things People Have Done With Excel
· Flexible uses for Excel at Home
· Using Find And Replace In Excel

Please browse our web site to find out more about
excel course in london and other Microsoft training courses.

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