Stutzman.org - Latest comments on IFERROR for Excel 2003

In response to: IFERROR for Excel 2003

Laurian [Visitor] — Thu, 29 Jul 2010 11:45:05 +0000

Thank you. This is exactly what I needed.

In response to: IFERROR for Excel 2003

Rob [Visitor] — Wed, 28 Jul 2010 12:26:34 +0000

Sweet ! Nice one . Rock solid dude!

In response to: IFERROR for Excel 2003

Jeff [Visitor] — Thu, 22 Jul 2010 17:19:45 +0000

Thank you. This is exactly what I needed.

In response to: IFERROR for Excel 2003

Peter P [Visitor] — Wed, 14 Jul 2010 14:39:15 +0000

You are a godsend to those that have been given legacy systems as backups when their main systems die. I have a few presentations this week and the IFERROR error was breaking all of my calcs in the spreadsheet. Thank you!

In response to: IFERROR for Excel 2003

chris [Visitor] — Fri, 11 Jun 2010 13:49:58 +0000

The IFERROR function returns a string. So if I wanted to represent =IFERROR(100/0,0) as a percentage or add decimal places with cell formatting, it will remain a 0 instead of 0% or 0.00. A fix can be to change this line:
Function IfError(formula As Variant, show As String)
to this line:
Function IfError(formula As Variant, show As Integer)
or any of the other VBA data types like 'Single' or 'Double' for more precise floating-point numbers.

In response to: IFERROR for Excel 2003

karuniadi [Visitor] — Fri, 11 Jun 2010 12:08:26 +0000

thank you for this usefull post
I have the problem too.

In response to: IFERROR for Excel 2003

Geoffrey [Visitor] — Thu, 08 Apr 2010 22:56:58 +0000

Old posts never die!!!

had the same issue as several of my field sales guys are still on 2003. This was a life savers. Thank God for you and Google!!

In response to: IFERROR for Excel 2003

Reinaldo [Visitor] — Sun, 21 Mar 2010 23:55:36 +0000

Excellent! Thanks a lot!