Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel worksheet functions.
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=497121 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
excel contents cells on different worksheet like a comment | Excel Discussion (Misc queries) | |||
Can I use variables for workheet name references in Excel functions? | Excel Discussion (Misc queries) | |||
Can I use variables for workheet name references in Excel functions? | Excel Worksheet Functions | |||
Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions |