Certificates

Resolved · Low Priority · Version 2007

Fri 10 Jun 2011, 13:14 Delegate Mitesh said...

Mitesh has attended:
Excel VBA Intro Intermediate course

Certificates

Hi,

I have just attended the VBA Intro and Intermediate course.

My company has requested a certificate as proof of my attendance and training that I received.

Is it possible for you to send me one please.

Thank you

Regards,

Mitesh

Fri 10 Jun 2011, 16:02 Trainer Yolande said...

RE: Certificates

Hi

Thanks for your certificate request, we've printed one off and it will be sent to you within a week.

Best regards

Yolande

Fri 17 Jun 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

Certificates

Certificates

RE: Certificates

Excel articles

Excel tip:

Stop Formula Returning A "#DIV/0" Error