IF Function
Sorry for taking so long to get back to you but had a family emergancy.
If I take out a bracket at the end I get the error message saying 'I have to
many arguements' then it highlights the first FALSE and B7. Not to sure why
it is doing this.
thanks
"Pete_UK" wrote:
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
.
|