Thread: IF Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default IF Function

Well, you do have an extra bracket at the end - you should have the
same number of open and closed brackets (parentheses) in a formula.

Hope this helps.

Pete

On Nov 13, 3:30*pm, Lisa Cowan
wrote:
I am using the below to hide the #N/A when the cell is not used. However I
keep on getting the error message @you have to many arguements for this
function' and highlighting B7 and the beginning and FALSE at the end.

probably really simple solution - please help

=IF(ISNA(LOOKUP(B7,Processes!$B$5:$B$150,Processes !$C$5:$C$150,FALSE)),"",L*OOKUP(B7,Processes!$B$5: $B$150,Processes!$C$5:$C$150,FALSE)))

thanks
Lisa