+ Reply to Thread
Results 1 to 2 of 2

And Function in Lotus 1-2-3

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    And Function in Lotus 1-2-3

    Hello All,

    Can any one please help me to let me know that how can i use "AND" function in lotus1-2-3 application
    Click on (*), if you agree.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: And Function in Lotus 1-2-3

    Short but useless answer. I expect we can help with Lotus @AND() function. Ideas to consider:

    1) I had trouble finding any online help for the old Lotus 123 @functions. As the "expert" in this thread on Lotus functions, can we assume that the old Lotus function is basically the same as Excel's AND() function, or are there significant differences in syntax for the old Lotus @function? I would expect that the old @AND() function is very similar to every other spreadsheet's AND() or @AND() function -- where you feed it one or more boolean expressions, it evaluates each boolean expression in the list, and returns TRUE if all of the expressions are TRUE and FALSE if any one of the arguments is FALSE. Is there any reason to expect different behavior from the old Lotus function?
    2) It seems that most of the time questions about an AND() function are not really about the syntax of the AND() function, but about the underlying logic behind the desired function. Have you put your desired logic into a truth table (https://en.wikipedia.org/wiki/Truth_table ) or decision flow chart (https://en.wikipedia.org/wiki/Flowchart ) or other tool for analyzing the desired logic of your @AND() function?
    3) Another thing to consider. I see a lot of AND() function questions that turn out to really be lookup problems. Don't forget to familiarize yourself with Lotus's lookup functions, in case a lookup is better than a series of AND() functions.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find Email in Lotus Note and export its content to Excel (VBA & Lotus Note)
    By mortphil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2014, 05:53 AM
  2. Lotus 123 had a function that Excel doesn't
    By Billybob K in forum Excel General
    Replies: 5
    Last Post: 08-01-2009, 01:47 PM
  3. Excel function that connects to Lotus Notes
    By DJSmith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2008, 12:43 PM
  4. [SOLVED] "Activeworkbook" function not valid when workbook embedded in Lotus Notes?
    By Punsterr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2006, 06:40 PM
  5. Converting Lotus function to Excel
    By Rubix in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2006, 06:00 AM
  6. How do I group worksheets (Lotus 123 function is "Sheet>Group Shee
    By jaking in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Old, LOTUS 1-2-3 based function
    By Gabor Szikla in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2005, 11:06 PM
  8. In Excel what can I use for the XINDEX function from Lotus 123?
    By Val from ICB in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1