How to get string to use IF formula only when another cell is text
Hi all,
Thanks for any suggestions, although I'm sure this is very simple, for
anyone other than myself...
If cell $A1 is text I want to use an IF formula. But if A1 is blank (or
number) I want to return a blank cell as the result.
ex:
A B C
1 boy 0 x
2 hat
3 0
4
5 123 0
6 124
The formula I've tried (that doesn't work) is:
=IF(ISTEXT(A1),(=if(B1=0,"x",""),"")
|