software

Can anybody tell me, What is the use of the quot;truequot; and quot;falsequot; worksheet
functions?--
balanand
------------------------------------------------------------------------
balanand's Profile: www.hightechtalks.com/m630
View this thread: www.hightechtalks.com/t2320006I 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)quot;balanandquot; gt; wrote in message
...
gt;
gt; Can anybody tell me, What is the use of the quot;truequot; and quot;falsequot; worksheet
gt; functions?
gt;
gt;
gt; --
gt; balanand
gt; ------------------------------------------------------------------------
gt; balanand's Profile: www.hightechtalks.com/m630
gt; View this thread: www.hightechtalks.com/t2320006
gt;

Boolean Logic's default answer is TRUE or FALSE for example.
If you use and AND statement - then if quot;bothquot; 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 quot;ORquot;
statement gives a quot;TRUEquot; or quot;FALSEquot; also, except that if any condition
is quot;TRUEquot; then the cell will indicate quot;TRUE.quot;
If you want a more representative type of quot;answerquot; in the cell then use
a combination of quot;IFquot; and quot;ANDquot; together or quot;IFquot; and quot;ORquot; together.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=497121I 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 =50gt;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)quot;wjohnsonquot; gt; wrote in
message ...
gt;
gt; Boolean Logic's default answer is TRUE or FALSE for example.
gt; If you use and AND statement - then if quot;bothquot; conditions are TRUE -
gt; then the cell which contains the answer will be TRUE. IF either of the
gt; 2 conditions is FALSE - then the CELL will indicate false. The quot;ORquot;
gt; statement gives a quot;TRUEquot; or quot;FALSEquot; also, except that if any condition
gt; is quot;TRUEquot; then the cell will indicate quot;TRUE.quot;
gt; If you want a more representative type of quot;answerquot; in the cell then use
gt; a combination of quot;IFquot; and quot;ANDquot; together or quot;IFquot; and quot;ORquot; together.
gt;
gt;
gt; --
gt; wjohnson
gt; ------------------------------------------------------------------------
gt; wjohnson's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29640
gt; View this thread: www.excelforum.com/showthread...hreadid=497121
gt;
Well, sometimes it helps when understanding a spreadsheet to see TRUE or
FALSE instead of 1 or 0.

--
rsenn
------------------------------------------------------------------------
rsenn's Profile: www.excelforum.com/member.php...oamp;userid=29050
View this thread: www.excelforum.com/showthread...hreadid=497121Sure, 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)quot;rsennquot; gt; wrote in
message ...
gt;
gt; Well, sometimes it helps when understanding a spreadsheet to see TRUE or
gt; FALSE instead of 1 or 0.
gt;
gt;
gt;
gt;
gt; --
gt; rsenn
gt; ------------------------------------------------------------------------
gt; rsenn's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29050
gt; View this thread: www.excelforum.com/showthread...hreadid=497121
gt;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:
gt; [...] the reason excel has 2 functions called TRUE and
gt; FALSE was to be compatible with Lotus 123 when Lotus was the main
gt; spreadsheet
gt; I really don't see any use of them
gt;