Iserror - too many arguments

[smartgal]

I have the followig formula:

=(if(iserror(HLOOKUP($B7,mm!$2:$23,22, 0),0,HLOOKUP($B7,mm!$2:$23,22, 0))

And I'm getting an error saying too many arguments. Help!

mm

 

[Per Jessen]

Hi

You are missing two closing parenthesis:

=(IF(ISERROR(HLOOKUP($B7,mm!$2:$23,22, 0)),0,HLOOKUP($B7,mm!$2:$23;22, 0)))

but you don't need the outer parenthesis:

=IF(ISERROR(HLOOKUP($B7,mm!$2:$23,22, 0)),0,HLOOKUP($B7,mm!$2:$23;22, 0))

Regards,
Per

 

[smartgal]

Me? Argue with Excel? Never!! I did try to add some ( ) but I guess I was
still missing one somewhere. Thanks~!