Forum Discussion

ccwid's avatar
ccwid
Copper Contributor
Jul 12, 2024

Prioritizing circular If statements?

When creating an amortization table in Excel I tried to place conditions on two of my columns using IF statements to return values based on other columns. When placing the second condition which involves the value of the cell of the first IF statement, I got a warning about a circular reference. This was fine as that's what I needed it to do so I turned on allow multiple iterations. Now I get values returned but it completes the second IF statement before the first causing the first statement to return true when it should be returning false in turn messing up my numbers. I tried managing rules under conditional formatting but nothing showed up, I also tried rearranging my values to no avail. I believe my logic is sound and I would like to try and use this method, so I'm wondering is there a way to prioritize one IF statement over the other or will I need to find another way to achieve this. 

  • ccwid 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources