How can I nest ISTEXT and IF functions?

G

Guest

I am sure this is probably simple and obvious, but I'm no Execl expert! I am
trying to make a cell return the value of 1 if true, 0 if false if another
cell (in another workbook) contains text. I can't seem to get IF and ISTEXT
to nest and I really don't want to have to create an entire separate range of
cells to perform the functions separately. Thanks in advance for your
help/advice.
 
P

Peo Sjoblom

=--(ISTEXT([Book1]Sheet1!$A$6))

as an example will return 1 for TRUE and 0 for FALSE

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 

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

Nesting if functions 1
Blank cells: ISBLANK = FALSE, ISTEXT = TRUE 3
Multiple functions 2
If a specified cell has any text entered in it, this cell will ent 2
nest functions in CELL function 1
Function that will = 1 of 4 cell containing text 5
How do I nest these 3 IF functions? 4
If function help 6

Top