formula errors

  • Thread starter Thread starter mrpick6
  • Start date Start date
M

mrpick6

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?
 
Sorry. Machine hiccup and it sent the message before I'd finished it.

Are you sure that the values in A1 and A2 are exactly 2 and 4 respectively,
or are they values which have been rounded to 2 and 4? What does =A1+A2-6
show you? What do you see if you format A1 and A2 and BC13 with 16 decimal
places or so?

Perhaps you want =IF(ROUND(BC13,0)=H10,1,0) or even
=IF(ROUND(BC13,0)=ROUND(H10,0),1,0) ?
 
Back
Top