Dear community,

I have a problem because first time I see something like this.

Formula IF with two logic AND criteria calculates correctly, but result is showing in Cell as 0 (zero).

In both marked Cells are Formulas like below. The calculation is correctly because Formula result show correct values (upper Cell should be =””, lower Cell should be =2), but as you see both are shown as =0.

Cell formating change is not helping to show the correct value.

Previously I had the same formula but second logic criteria was just checking one, direct, upper Cell and everything was showing correctly, but I need only one value in range Q15:Q35, so I had to change it.

Please help me to uderstand or give me some ideas for investigation.

​Dear community, I have a problem because first time I see something like this.Formula IF with two logic AND criteria calculates correctly, but result is showing in Cell as 0 (zero).In both marked Cells are Formulas like below. The calculation is correctly because Formula result show correct values (upper Cell should be =””, lower Cell should be =2), but as you see both are shown as =0.Cell formating change is not helping to show the correct value. Previously I had the same formula but second logic criteria was just checking one, direct, upper Cell and everything was showing correctly, but I need only one value in range Q15:Q35, so I had to change it.Please help me to uderstand or give me some ideas for investigation.     Read More

​