Forum Discussion
Formula calculation displayed wrongly (IF results)
If you look at the status bar at the bottom, you'll see that the sheet has circular references, i.e. formulas that refer to the cell containing that formula.
This prevents Excel from recalculating formulas correctly.
The circular reference occurs in G5:G14. The formula in G5 is
=IF(AND(E5>=$F$2,SUM(G$4:$G5)=0),MAX($F$5:$F$14),"")
As you can see, the formula refers to G5 itself.
Change the formula to
=IF(AND(E5>=$F$2,SUM(G$4:$G4)=0),MAX($F$5:$F$14),"")
and then fill down to G14.
The circular reference warning disappears, and the formulas return the desired result:
If you look at the status bar at the bottom, you'll see that the sheet has circular references, i.e. formulas that refer to the cell containing that formula.
This prevents Excel from recalculating formulas correctly.
The circular reference occurs in G5:G14. The formula in G5 is
=IF(AND(E5>=$F$2,SUM(G$4:$G5)=0),MAX($F$5:$F$14),"")
As you can see, the formula refers to G5 itself.
Change the formula to
=IF(AND(E5>=$F$2,SUM(G$4:$G4)=0),MAX($F$5:$F$14),"")
and then fill down to G14.
The circular reference warning disappears, and the formulas return the desired result:
I was not expecting that this could be the problem because I get warning only for the circular reference in only one cell and problem was general, but you was right.
Thank you once more.