Excel worksheet functions.

[balanand]

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

[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)


"balanand" <balanand.20w9xz@no-mx.forums.yourdomain.com.au> wrote in message
news:balanand.20w9xz@no-mx.forums.yourdomain.com.au...
>
> 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
>

[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 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.

[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)


"wjohnson" <wjohnson.20xfly_1136070001.1807@excelforum-nospam.com> wrote in
message news:wjohnson.20xfly_1136070001.1807@excelforum-nospam.com...
>
> 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
>

[rsenn]

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

[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)


"rsenn" <rsenn.20zkxa_1136170201.5137@excelforum-nospam.com> wrote in
message news:rsenn.20zkxa_1136170201.5137@excelforum-nospam.com...
>
> Well, sometimes it helps when understanding a spreadsheet to see TRUE or
> FALSE instead of 1 or 0.
>
>
>
>
> --
> rsenn
> ------------------------------------------------------------------------
> rsenn's Profile:
> http://www.excelforum.com/member.php...o&userid=29050
> View this thread: http://www.excelforum.com/showthread...hreadid=497121
>

[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?

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
>