Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Iserror - too many arguments
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Iserror - too many arguments
If you'll look at the formula in the formula bar when you get the error, you will see that the zero show in bold below is also shown in bold in the formula bar. Excel is trying to tell you where it thinks the problem is (and don't argue with Excel!) =(if(iserror(HLOOKUP($B7,mm!$2:$23,22, 0),*0*,HLOOKUP($B7,mm!$2:$23,22, 0)) Specifically, the iserror function takes one argument and you are missing a parenthesis to close off the iserror() format: =(if(iserror(HLOOKUP($B7,mm!$2:$23,22, 0)*)*,0,HLOOKUP($B7,mm!$2:$23,22, 0)) But once you make that change, Excel will count parentheses and tell you that the ones in your formula don't balance, so the final version will be =(if(iserror(HLOOKUP($B7,mm!$2:$23,22, 0)),0,HLOOKUP($B7,mm!$2:$23,22, 0))*)* In cases like this, it's always good to test out the components of the formula individually - ie, the iserror part, the lookup part in a cell formula of their own to find what the problem might be. -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111723 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Iserror - too many arguments
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" skrev i meddelelsen ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Iserror - too many arguments
Me? Argue with Excel? Never!! I did try to add some ( ) but I guess I was
still missing one somewhere. Thanks~! "jamescox" wrote: If you'll look at the formula in the formula bar when you get the error, you will see that the zero show in bold below is also shown in bold in the formula bar. Excel is trying to tell you where it thinks the problem is (and don't argue with Excel!) =(if(iserror(HLOOKUP($B7,mm!$2:$23,22, 0),*0*,HLOOKUP($B7,mm!$2:$23,22, 0)) Specifically, the iserror function takes one argument and you are missing a parenthesis to close off the iserror() format: =(if(iserror(HLOOKUP($B7,mm!$2:$23,22, 0)*)*,0,HLOOKUP($B7,mm!$2:$23,22, 0)) But once you make that change, Excel will count parentheses and tell you that the ones in your formula don't balance, so the final version will be =(if(iserror(HLOOKUP($B7,mm!$2:$23,22, 0)),0,HLOOKUP($B7,mm!$2:$23,22, 0))*)* In cases like this, it's always good to test out the components of the formula individually - ie, the iserror part, the lookup part in a cell formula of their own to find what the problem might be. -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111723 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Iserror help | Excel Discussion (Misc queries) | |||
ISERROR | Excel Worksheet Functions | |||
iserror | Excel Worksheet Functions | |||
ISERROR | Excel Worksheet Functions | |||
iserror | Excel Worksheet Functions |