If and statement should = 0 instead of "true"

[jonvanwyk]

=IF(AND(B5="FamSick",C5=1),B49+B89,0)

In my spreadsheet right now, the value of B5 is 0:00 while the value of C5 is 3. With this being the case, B49 and B89 should not be added to create a result. (Even if they were added, both contain a value of 0 right now, so that value would still be 0.)

Instead of the above forumla equalling 0, it is making it equal TRUE. Any ideas?

P.S. The formula in this case is found in cell B155

[NBVC]

if you hit F9.. does it recalc properly?

[jonvanwyk]

if you hit F9.. does it recalc properly?

Do I have to have anything selected when I hit F9? I had the cell selected that contains the above formula and nothing occurred.

[martindwilson]

works ok for me

[jonvanwyk]

works ok for me

I edited the original post to include the excel file I am working from. Cell B155 is the cell that contains this particular formula.

[NBVC]

It doesn't matter the cell selected when hitting F9.. it should recalc the sheet.

Are you sure about the cells you are referencing.. is it in fact B5 and C5 you are looking at?

Maybe you can post the sheet.. it should work as is...

[NBVC]

You somehow put the same formula in the cell twice...

Expand the formula bar to make it higher and you will see the formula twice in B155

[martindwilson]

bi55 appears to strangely have 2 formulas in it! delete one of them
i see nbvc has spotted that too!
essentially its saying
=IF(AND(B5="FamSick",C5=1),B49+B89,0)=IF(AND(B5="FamSick",C5=1),B49+B89,0)
which they do hence true

[jonvanwyk]

bi55 appears to strangely have 2 formulas in it! delete one of them
i see nbvc has spotted that too!
essentially its saying
=IF(AND(B5="FamSick",C5=1),B49+B89,0)=IF(AND(B5="FamSick",C5=1),B49+B89,0)
which they do hence true

Thank you for noticing...both of you. I had a hard time even seeing it in there twice. It is now fixed and working!