I don't think that was the question posted, the OP wanted to know why the
functions TRUE or FALSE are built in,
not why for instance =502 returns the Boolean TRUE. Bob already answered
the question, the reason excel has 2 functions called TRUE and FALSE was to
be compatible with Lotus 123 when Lotus was the main spreadsheet
I really don't see any use of them

--
Regards,

Peo Sjoblom

(No private emails please)


"wjohnson" wrote in
message ...

Boolean Logic's default answer is TRUE or FALSE for example.
If you use and AND statement - then if "both" conditions are TRUE -
then the cell which contains the answer will be TRUE. IF either of the
2 conditions is FALSE - then the CELL will indicate false. The "OR"
statement gives a "TRUE" or "FALSE" also, except that if any condition
is "TRUE" then the cell will indicate "TRUE."
If you want a more representative type of "answer" in the cell then use
a combination of "IF" and "AND" together or "IF" and "OR" together.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile:
http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=497121