How can I rewrite IF IsError Function to Work in VBA
 

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)

How can I rewrite IF IsError Function to Work in VBA
 

"DogLover" 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)