Excel worksheet functions.
 

Can anybody tell me, What is the use of the "true" and "false" worksheet
functions?


--
balanand
------------------------------------------------------------------------
balanand's Profile: http://www.hightechtalks.com/m630
View this thread: http://www.hightechtalks.com/t2320006

Excel worksheet functions.
 

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)


"balanand" wrote in message
...

Can anybody tell me, What is the use of the "true" and "false" worksheet
functions?


--
balanand
------------------------------------------------------------------------
balanand's Profile: http://www.hightechtalks.com/m630
View this thread: http://www.hightechtalks.com/t2320006

Excel worksheet functions.
 

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

Excel worksheet functions.
 

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

Excel worksheet functions.
 

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

:rolleyes:


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

Excel worksheet functions.
 

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)


"rsenn" wrote in
message ...

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

:rolleyes:


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

Excel worksheet functions.
 

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?

Peo Sjoblom wrote:
[...] 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