IF functions not calculating

I have a series of IF functions calculating on the basis of certain cells. Eg:

=IF(BBR54=".",".",IF(AND(BBR54="1",BBR56="1"),"1",0))

On checking the results, I have found that for certain columns, some of the calculations are NOT calculating. That is, if the IF calc criteria are met, I'd expect a '1' returned, but sometimes it isn't. However, if I input '1' into the source cells, then the calculation works as expected.

I have tried using source/calc cells as numbers or as text (as in the calc above). Neither always works. Lastly, I have tried copying source cells and pasting them, but no improvement.

Any ideas?

Could it be that your 1s are numeric and not text?

It looks like a fairly simple decision tree with three possible outcomes:

Outcome 1) If BBR54 is ".", then return ".".
Outcome 2) If BBR54 and BBR56 are both "1", then return "1".
Outcome 3) Any other condition, then return 0.

Is that an accurate description of the intended decision tree? When the decision tree fails, what are the exact values of BBR54 and BBR56? What value is returned? What value did you expect?

For something like this, I would expect the "Evaluate formula" tool to be a useful debugging tool: https://support.microsoft.com/en-us/...rs=en-us&ad=us

When the decision tree fails, what are the exact values of BBR54 and BBR56? Both 1.

Insufficient. Stating that both cells contain a 1 does not go far enough to describe exactly what is in those cells. It's already been mentioned, but are they 1 stored as text or are they 1 stored as a number (ISTEXT() and ISNUMBER() can be useful functions for determining which data type is being stored)? If they are 1 stored as text, are there any extraneous, invisible characters (space or carriage return or some such)? I find LEN(), CODE(), MID(), and similar text functions useful for determining if there are extraneous invisible characters. If they are 1 stored as a number, is the value exactly 1.00000000....., or is it a value that is not exactly 1 but close enough to 1 to be displayed as 1 according to the display parameters (cell width and number format and such)?

If Excel is choosing to return 0 with this function, then something about the ones stored in the cells and the 1.00000000000000 number you've hardcoded in the function is different. Debugging this sort of thing is all about finding that difference.