Assuming no intervening columns CAN contain the text, try this untested
=if(or(x230="favorable",countif(ag230:bd230,"overt urned")<1),"",if(bn230<0,"yes","no"))


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"akemeny" wrote in message
...
Ok... heres what I'm working with. I have a spreadsheet that contains
links
to other spreadsheets. In this linked spreadsheet I also have one column
that is not linked (column BQ) which is where the function is going.

Here's where I get stumped. The current function that I'm using is:

=IF(X230="favorable","",
IF(BN230="","No",IF(OR(BN230="",BD230="overturned" ,AW230="overturned",AN230="overturned",AG230="over turned"),"No",IF(BN230<"0","Yes",""))))

What I need for the function to do is:
1. Look at columns BD, AW, AN, AG for the term "Overturned"
2. Look at column BN for a balance (will be a negative balance)
3. Change the cell value that contains the function to No if 1 is true and
2
is false
4. Change the cell value that contains the function to Yes if both are
true
5. Leave the cell blank if it doesn't find Overturned in 1

Any help would be greatly appreciated.