Possible IS(TEXT) & IS(NUMBER) Question

[Disarmonious]

Hello,

I'm working with 3 cells on this question. I want cell (G6) to display a left arrow ("×" with 'Wingdings' font) and when a name is typed or pasted into cell (E6), I then want a right arrow ("Ø" with 'Wingdings' font) to replace the left arrow in this cell, where when the user enters a number into cell (I6), this arrow (both arrows) will disappear, and the cell be blank. I've been trying to create this formula for an hour or so, and it's driving me crazy. I know there's a simple formula out there? Here's what I have so far;

Cell G4: =IF(ISTEXT(E6),"Ø",IF(ISNUMBER(I6),"","×"))

Of course, this formula doesn't tell cell (G6) to display nothing when information is entered into cells (E6) and (I6)

 

[Jonmo1]

It'd difficult to understand which value you want based on which cells..

Fill in the ?? marks

E6 Contains Text AND I6 Contains Number: I Want ???
E6 Contains Text AND I6 is Empty: I Want ???
E6 is Empty and I6 Contains Number: I Want ???
E6 is Empty and I6 is Empty: I Want ???

 

[Disarmonious]

Hello,

I'm sorry to sound so confusing.

E6 Contains Text AND I6 Contains Number: G6 = Blank or Nothing
E6 Contains Text AND I6 is Empty: Right Arrow Pointing to I6
E6 is Empty and I6 Contains Number: Left Arrow Pointing to E6
E6 is Empty and I6 is Empty: Left Arrow Pointing to E6

 

[Jonmo1]

"x" = Left Arrow
"0" = Right Arrow

=IF(E6="","0",IF(I6="","x",""))

This is making a couple assumptions in order to make it simpler..
Assumes that E6 can only be a TEXT value or EMPTY, in other words, if E6 is NOT empty, it therefore must contain a Text value.
Same for I6, it can only contain a Number or Empty, if it's NOT empty, it therefore must contain a number.

 

[Disarmonious]

Jonmo1,

Thank you my friend. Works like a charm. I can not believe I couldn't come up with this formula.

 

[Jonmo1]

You're welcome.