Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Function help
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced cell function. is it possible | Excel Worksheet Functions | |||
Advanced use of LARGE function | Excel Worksheet Functions | |||
Advanced Filter Function | Excel Worksheet Functions | |||
Advanced IF function | Excel Worksheet Functions | |||
Advanced COUNTIF Function | Excel Worksheet Functions |