If statement false value referencing same cell as formula cell

[OandGmodeling]

Checking a outside model that I received and the if statement false value is referencing the cell in which the formula is being written. If I try to recreate this, I obviously get zero, which is not the value the cell in the model is returning when the logic is false. My question is, how is an if statement returning a distinct value when false if it is referencing the same cell the formula is being written in. Example below.

Assume if statement is being written in cell A1:

=IF(C$1=$B$1,'sheet2'!$BG4,A1)

instead of producing a value of zero, the model produces a specific number when false.

Thanks!

 

[mole999]

maybe the iteration is set to zero or one

 

[OandGmodeling]

I checked but it wasn't that. Thanks for the reply!