philpre
asked on
Problem with Excel Formula Calculation
Hi,
I am working on an excel worksheet and I am encountering a circular reference error. I have attached the Excel spreadsheet. I encounter the problem when I change the formula in cell B8 to test for another condition (W8 <> 0) in the IF statement. The formula works fine until I add W8 to the statement.
=IF(AND(I8>=$AM$6,R8<>0,S8 <>0,T8<>0, U8<>0,W8<> 0,X8<>0),1 ,IF(AND(I8 <=$AM$7,R8 <>0,S8<>0, T8<>0,U8<> 0,W8<>0,X8 <>0),-1,0) )
Excel-Question.xlsx
I am working on an excel worksheet and I am encountering a circular reference error. I have attached the Excel spreadsheet. I encounter the problem when I change the formula in cell B8 to test for another condition (W8 <> 0) in the IF statement. The formula works fine until I add W8 to the statement.
=IF(AND(I8>=$AM$6,R8<>0,S8
Excel-Question.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER