Hi Andrea,

You cannot add such a lot of if condiions, without telling it what to do!If
any of these statements are true, what should happen, and if they are false,
what should happen! After your last comma, you must tell Excel what to do if
this is true, and add another comma to tell it what to do if these are false.

One way is to list your if's in an OR statement, that is if thin the event
that any one of these are true, the same thing should happen. Excel will
check each condition until it either reaches the end, then go to you false
satement, or until one returns true, in which case it will return your true
option.
=IF(OR(ISERROR(Sheet2!L128),ISDERROR(Sheet2!L129), ISERROR(Sheet2!L130),ISERROR(Sheett2!L131),ISERROR (Sheet2!L132),ISERROR(Sheet2!L133),ISERROR(Sheet2! L134),
what do you want to happen if any one is true, what do you want to happen if
all are false). All this must be in one line.

Otherwise, you must say =IF(ISERROR(Sheet2!L128),do
something,IF(ISERROR(Sheet2!L129),do something,IF(ISERROR(Sheet2!L130),do
something.....IF(ISERROR(Sheet2!L134),do something, do something else)))))))
Also, remember that you can only use 7 such IF's consecutievely.

As far as your other problem is concerned, then

=IF(ISERROR(B22,"",IF(B22="human",L36,"")) should work

--
HTH

Kassie

Replace xxx with hotmail


"Andrea" wrote:

=IF(Sheet2!L128,FALSE,IF(Sheet2!L129,FALSE,IF(Shee t2!L130,FALSE,IF(Sheet2!L131,FALSE,IF(Sheet2!L132, FALSE,IF(Sheet2!L133,FALSE,IF(Sheet2!L134,FALSE,Sh eet2!L203)))))))

returns error #value!
=IF(B22="human",L36) returns a flase to the cell
what I want it to do is display the text that is in the field if it is not
false