making a decision tree using excel!

[andrew h via OfficeKB.com]

hello all, i`ve been trying to make a decision tree using excel, the problem
i encounter is that i wish to put information in to b11 which is related to
information in b3, the information in b3 is ether 0 or err and is based on a
"y" or "n" being entered, does anyone know which formula to use which will
print a true of false statement in b11

 

[David McRitchie]

Hi Andrew,
If you mean print "True" or "False" or your error

b11: =Left(b3)="y"

So you can use YES, Yes, yes, Y, y and get True
everything else will show False

Or to treat the error in B3 as False, you might want to use
B11: =IF(ISERR(B3),FALSE,LEFT(B3)="Y")

FWIW (For What It's Worth)
Most worksheet formulas are not case sensitive
Most VBA comparisons are case sensitve
http://www.mvps.org/dmcritchie/excel/strings.htm
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

hello all, i`ve been trying to make a decision tree using excel, the problem
i encounter is that i wish to put information in to b11 which is related to
information in b3, the information in b3 is ether 0 or err and is based on a
"y" or "n" being entered, does anyone know which formula to use which will
print a true of false statement in b11

-------------
Posting questions to newsgroups from so called "forums" end up on websites
in addition to the newsgroups and this really screws up web searches as it is
necessary to suppress a long list of sites full of advertising that repeat newsgroup
postings. Google search (web searches), and you have Google Groups
(for newsgroup searchs) but sites that send questions to newsgroups screw
up the distinction and instead of finding what you in a search you get 95% noise
in top hits.