istext

[uk747]

=IF(ISTEXT(a3),a3,IF(ISTEXT(a2),a2,"")) cant seem to get the formula to work.A3 contains a formula and A2 doesnt. If the formula in A3 shows text based on a result then I want contents of A3 in A1, if A3 is "" then show A2 and if A2 is blank then ""

 

[RoryA]

Is A3 either some text or "", or could it be a number? (the "" is actually text too)

 

[Sixthsense]

Try this...

=IF(AND(LEN(A3),ISTEXT(A3)),A3,IF(AND(LEN(A2),ISTEXT(A2)),A2,""))

 

[Dryver14]

There is nothing wrong with the formula.

 

[uk747]

Is A3 either some text or "", or could it be a number? (the "" is actually text too)

a3 is a formula based on other cells if the other cells are blank then A3 will show as blank

 

[Dryver14]

when the formula in A3 returns something ...what is that? What I mean by that is do you mean text or do you just mean not blank,
is a number coming over?

 

[Sixthsense]

I am curious to know whether Post #3 doesn't help you?

 

[uk747]

when the formula in A3 returns something ...what is that? What I mean by that is do you mean text or do you just mean not blank,is a number coming over?

the result of the formula is text.

 

[uk747]

Try this...

=IF(AND(LEN(A3),ISTEXT(A3)),A3,IF(AND(LEN(A2),ISTEXT(A2)),A2,""))

I am curious to know whether Post #3 doesn't help you?

sorry only just seen your post. yes it did work Thanksif A4 was involved as well how would that slot into the formulaif a4 is blank then show a3, if a3 is blank then show a2 if a4 a3 and a2 are blank then a1 will be blank

 

[Sixthsense]

Glad it helps you just duplicate one of the if function and change the cell reference like the below

=[COLOR=#0000cd]IF(AND(LEN([/COLOR][COLOR=#ff0000]A4[/COLOR][COLOR=#0000cd]),ISTEXT([/COLOR][COLOR=#ff0000]A4[/COLOR][COLOR=#0000cd])),[/COLOR][COLOR=#ff0000]A4[/COLOR],[COLOR=#0000cd]IF(AND(LEN(A3),ISTEXT(A3)),A3[/COLOR],[COLOR=#0000cd]IF(AND(LEN(A2),ISTEXT(A2)),A2[/COLOR],"")))