I appear to have a problem with formulas in Excel. formulas where a cell
containing a formula cannot be compared to a cell containing an input value
example: =IF(BC13=H10,1,0) where BC13 is a formula referencing other cells
to return a numerical result and H10= input value. The formula was working
last week, and suddenly it fails. Example of cell BC13: =A1+A2 if A1=2 and
A2=4 the result comes back as 6 a correct answer, but if I type 6 into cell
H10, the logic formula returns 0, not the intended 1 result.

What is going wrong and how do I fix the problem?