View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GoinCrazy GoinCrazy is offline
external usenet poster
 
Posts: 2
Default 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",""),"")