With either of the two functions that were given to me... where would I put
the following:

If BJ230="",""

So that it won't take into account the rows that do not contain blank values
for BJ

"akemeny" wrote:

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.