How to get string to use IF formula only when another cell is text

G

GoinCrazy

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",""),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Not blank - Formula for two cells 0
If, Or, and 5
Referencing the values of multiple cells in conditinal formatting. 0
Help with an if then scenario 2
Show a cell's formula in text format in a linked cell 2
Formula than understands midnight? 26
Use TODAY() function as the criteria in a SUMIF formula 1
How do I put a blank value in a cell not using "" in a formula 2

Top