Iserror - too many arguments

  • Thread starter Thread starter smartgal
  • Start date Start date
S

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
 
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
 
Me? Argue with Excel? Never!! I did try to add some ( ) but I guess I was
still missing one somewhere. Thanks~!
 
Back
Top