ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   is there an AND logical ? (https://www.excelbanter.com/excel-worksheet-functions/231005-re-there-logical.html)

Don Guillett

is there an AND logical ?
 
You're right. I had to type in

and function

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message news:...
How about the little
"type a question for help" on the menu bar.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Glenn" wrote in message
...
Don Guillett wrote:
Perhaps a search in the HELP index for
AND
would be of assistance



I always used to think that, but in Excel 2003 if you select "Offline
Help" and search for:

and
AND

you get nothing. And if you try:

AND Worksheet Function

you get a whole bunch of "worksheet functions", including "RAND worksheet
function", but no "AND worksheet function". But if you search for:

logic
logical

you will find "AND worksheet function".




Glenn

is there an AND logical ?
 
Don Guillett wrote:
You're right. I had to type in

and function



And still, that works only if "Microsoft Office Online" is selected for where to
search. Offline Help still fails to be helpful.

Glenn

is there an AND logical ?
 
Glenn wrote:
Don Guillett wrote:
You're right. I had to type in

and function



And still, that works only if "Microsoft Office Online" is selected for
where to search. Offline Help still fails to be helpful.



OK, now I get it. Offline Help works with "and function" but not with "and
worksheet function", even though the result that comes up is "AND worksheet
function".

Funny that this is considered a "Logical" function.


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com