[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

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
0
philpre
Asked:
philpre
1 Solution
 
tygrus2Commented:
Try changing "Maximum iterations"
Tools->Options
"Calculation" tab
Tick "Iteration"
Set "Maximum iterations" [default 100] = 1000
Set "Maximum change" [default 0.001] = 0.00001
OK
0
 
philpreAuthor Commented:
Thank you!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now