Help!

[Anon]

Hello

I hope someone can help me with a basic excel formula.

I have 4 cells of which only 1 will have information.
I need a formula that will look at all the 4 cells and display only the cell with information.
If more than 1 cell has info then FALSE needs to appear.

Regards

Eric

[Anon]

Try this formula, which assumes that the four cells are a1:d1:

IF(COUNTBLANK(A1😃1)=3,IF(ISTEXT(A1)+OR(ISNUMBER(A1)),A1,IF(ISTEXT(B1)+OR(ISNUMBER(B1)),B1,IF(ISTEXT(C1)+OR(ISNUMBER(C1)),C1,IF(ISTEXT(D1)+OR(ISNUMBER(D1)),D1)))),IF(COUNTBLANK(A1😃1)>3,FALSE))