Excel worksheet functions.

B

Bob Phillips

I cannot answer your question, as I have never seen them used, but I can
make some guesses. In the early days. MS were obsessed with the competition,
especially 123, and built features of them into their products. The
TRUE/FALSE functions could well be as a result of this. In Excel they are
unnecessary AFAICS because tests resolve to True or False anyway, so
something like

=IF(A1=17,

has a True or False alternative action. Similarly, if a cell resolves to
TRUE or FALSE, you don't need to test it, as

IF(A20,

is the same as

IF(A20=TRUE,




--

HTH

RP
(remove nothere from the email address if mailing direct)
 
W

wjohnson

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 th
2 conditions is FALSE - then the CELL will indicate false. The "OR
statement gives a "TRUE" or "FALSE" also, except that if any conditio
is "TRUE" then the cell will indicate "TRUE."
If you want a more representative type of "answer" in the cell then us
a combination of "IF" and "AND" together or "IF" and "OR" together
 
P

Peo Sjoblom

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 =50>2 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)
 
R

rsenn

Well, sometimes it helps when understanding a spreadsheet to see TRUE or
FALSE instead of 1 or 0.

:rolleyes:
 
P

Peo Sjoblom

Sure, that is why one use conditions that return TRUE or FALSE, can you give
me an example where you would use the function

=TRUE()

?

Besides the OP wanted to know why the functions TRUE and FALSE are there,
not why one can see the Boolean values TRUE or FALSE

--
Regards,

Peo Sjoblom

(No private emails please)
 
A

Aladin Akyurek

Just curious: How would the following look like

=IF(A1,A1,#N/A)
=IF(A1,A1,FALSE)
=IF(A1,A1,NA())
=IF(A1,A1,FALSE())

if the workbook containing these formulas were opened in a non-English
system?
 
Top