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. 

​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.   Read More

​