How can I rewrite IF IsError Function to Work in VBA

's Computer Specifications

I am trying to write this code in VBA. Does anyone know the best code to
make this work?

If (IsError(mSumIfs / Kountifs),"NA", mSumIfs / Kountifs)

's Computer Specifications

"DogLover" <(E-Mail Removed)> wrote:
> I am trying to write this code in VBA. Does anyone know
> the best code to make this work?
> If (IsError(mSumIfs / Kountifs),"NA", mSumIfs / Kountifs)

One way:

Dim z as Variant
On Error Resume Next
z = mSumIfs / Kountifs
If Err <> 0 Then z = "NA"
On Error GoTo 0

If you meant the Excel error #NA instead of the string "NA", then:

If Err <> 0 Then z = CVErr(xlErrNA)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF(ISERROR function	Greg	Microsoft Excel Programming	2	17th Nov 2006 06:06 PM
ISERROR function	Len	Microsoft Excel Programming	5	21st Apr 2005 02:30 AM
how do I write a vlookup function within an iserror function so t.	=?Utf-8?B?SkJMZWVkcw==?=	Microsoft Excel Worksheet Functions	2	16th Mar 2005 10:30 AM
iserror function	Carl Johnson	Microsoft Excel Misc	1	5th Sep 2003 07:51 PM
IsError Function	Barry	Microsoft Access Reports	1	24th Jul 2003 07:53 AM