The formula in the image below in cell D25 is`=IF(B25,C25, 0)`

, and the formula is copied to the other cells in that column. This means cells in the D column should take on the value in the C column (same row) if the B column cell for that row evaluates to TRUE (e.g. =1). Yet, this one's evaluating to 1 instead of 0.5 as it should. Why?

Automatic formula calculation is **on** and I did a Calculate Now before taking this screenshot.