formula errors

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?
 
D

David Biddulph

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) ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Newbie Help - IF Yes No Function 0
Data Validation - Complex Q 2
Drop down list control value in vba 2
VBA Coding Help for Beginner 0
Would like to input 3 letters into a cell, each having a different numerical value 5
VB code. If statement between two values 1
Multiple Criteria, One Answer 1

Top