Seamus2626
asked on
IF Statement ignore False
Hi i have an IF which i am trying to ignore errors and FALSE
=IF(ISERROR(BD2),"",IF(AI2 <>BD2,"Re- assigned", "Assigned" ))
The above ignores the errors but still shows results with "FALSE"
Can anyone add something in to also ignore "FALSE"
Note this lookup is looking up another lookup
Thanks
Seamus
=IF(ISERROR(BD2),"",IF(AI2
The above ignores the errors but still shows results with "FALSE"
Can anyone add something in to also ignore "FALSE"
Note this lookup is looking up another lookup
Thanks
Seamus
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to ignore errors and also cases where cell BD2 contains "FALSE", use the formula kgerb proposed.
ASKER
Hey, attached is an example, go across to BD1+BD2 and i have highlighted them red, basically when the lookup in BE1 recognises that BD1 is FALSE, it needs to return blank
Thanks
Seamus
test.xls
Thanks
Seamus
test.xls
ASKER
Thats the one!
Thanks
Seamus
Thanks
Seamus
You're welcome :)
Kyle
Kyle
can you post the worksheet in question ?