Excel 2010 not displaying correct formula result

[Dave2U]

Greetings,

I have an Excel 2010 workbook that uses a "combo-IF" formula to summarize results from another worksheet. Using the same formular, I am able to obtain and display the correct result in 4 cells of the summary worksheet. But I am unable to display the correct result in at least 2 cells. The remaining two cells are null values and have not been tested.

The fx ["Function Arguments"] dialog indicates the correct formula result = 1 while the cell insists on displaying "0". I have attempted changing the formatting, re-entering the formula and "find and replace" the equal sign in the formula. I have noticed that the correctly functioning formulas in the 4 cells have the entire formula (including the "=") surrounded by { and }. If I attempt to manually replicate these braces in the formula in question, it does not allow me to click on the formula checkmark.

Any assistance you can render would be greatly appreciated.

Dave2U