=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 ""
=IF(AND(LEN(A3),ISTEXT(A3)),A3,IF(AND(LEN(A2),ISTEXT(A2)),A2,""))
a3 is a formula based on other cells if the other cells are blank then A3 will show as blankIs A3 either some text or "", or could it be a number? (the "" is actually text too)
the result of the formula is text.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?
Try this...Code:=IF(AND(LEN(A3),ISTEXT(A3)),A3,IF(AND(LEN(A2),ISTEXT(A2)),A2,""))
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 blankI am curious to know whether Post #3 doesn't help you?
=[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],"")))