Hello,
I have A1 and B1. There are three situations:
A1 B1
Situation 1. Number Text
Situation 2 Text Number
Situatio 3 Number Number
C1 should show number for first two cases and higher number in third case. Also if in first two cases the number is 0, C1 should be Blank.
It is ok if can be done by more than one step
Please help me guys. I do really appreciate your help.
I have A1 and B1. There are three situations:
A1 B1
Situation 1. Number Text
Situation 2 Text Number
Situatio 3 Number Number
C1 should show number for first two cases and higher number in third case. Also if in first two cases the number is 0, C1 should be Blank.
It is ok if can be done by more than one step
Please help me guys. I do really appreciate your help.
Last edited: