Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Its all about where you put your closing bracket in this example Andrea!
Correct would be =IF(ISERROR(Sheet2!B22),"",IF(Sheet2!B22="human",S heet2!L117,"")) After iserror, you opened a bracket, which must be closed again after Sheet2!B22. Not to worry, I have received your sheet, and will take a look at it. -- HTH Kassie Replace xxx with hotmail "Andrea" wrote: I appreciate the help but .... =IF(ISERROR(Sheet2!B22,"",IF(Sheet2!B22="human",Sh eet2!L117,"")) gets me the following message... you have entered to many arguments for this function I am wondering if it might be easier to email the sheet, so you see what I have at issue here.? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question on XML in Excel 2003 | Excel Discussion (Misc queries) | |||
Question for MVP - install Excel 2003 on MS Server 2003 | Setting up and Configuration of Excel | |||
Excel 2003 Question | Excel Discussion (Misc queries) | |||
excel 2003 question | Excel Worksheet Functions | |||
Question about Excel 2003 | Excel Discussion (Misc queries) |