Test of the content of a cell, which is a formula

[mad4max]

I need to create a product label concatenating the content of several cells... Now, some of them can be empty and other not...
Let's imagine that I have in a cell the result of several other cells, concatenated...
A1 contains "" or could contain a value
B1 contains "" or could contain a value
C1 contains "" or could contain a value


E1 contain: A1&" "&B1&" "&C1

Now, in the cell G1 I need to test the result of E1 and if there is a value, then put A, but if the A1, B1, C1 just contain "", then should show B...


How to construct the furmula in G1?

Thank you everybody...

 

[steve the fish]

Presuming there could be spaces in A1, B1 and C1 also then try this:

=IF(E1=REPT(" ",LEN(E1)),"B","A")

 

[mad4max]

It works perfectly... Thank you very much for your help!!!

Presuming there could be spaces in A1, B1 and C1 also then try this:

=IF(E1=REPT(" ",LEN(E1)),"B","A")