Formula adds a zero to the final value

[Luisftv]

Formula adds a zero to the final value

I need some help please.

Please see attached file.

The gray cells are a result of formulas referring to other cells.

The yellow cells will only contain X or be blank.


For the red cell, the DESIRED RESULT:
If the yellow cells are blank, then the red cell should return 0 (zero) - as a number.
If one of the yellow cells has an X, then it should return the value contained in the corresponding gray cell (either 5 or 9).
If both cells have an X, then it should return their combined value (not added, but as two numbers put together, in this case 95).

CURRENT PROBLEM:
When the yellow cells have an X, it add the zero to the value of the gray cell to make it 50 instead of 5, or 90 instead of 9, or 950 instead of 95.

How to stop adding 0 (zero) to the result when the yellow cells contains an X, but still have 0 if the yellow cells are blanks?

In other words, all the possible results should be: 5, or 9, or 95, or 0 (zero).

[mehmetcik]

=if(bc3&bc4="xx",bc2*10+bc1,if(bc3="x",bc1,0)+if(bc4="x",bc2,0))

[WideBoyDixon]

Please Login or Register  to view this content.

Is this working for you?

WBD

[TMS]

And another:

Please Login or Register  to view this content.

[Luisftv]

Amazing!!! Thank you so much.

All the solutions do exactly what it is needed.

The only one I needed to add a 0 (zero) in the formula was in post #3, by WideBoyDixon, and then it works flawlessly. Here it is with the zero:

Please Login or Register  to view this content.

Thank you mehmetcik. Thank you WideBoyDixon. Thank you TMS.

I will analyze each solution and make sure I learn from them all.

[TMS]

You're welcome. Thanks for the rep.