Hello All,
Can any one please help me to let me know that how can i use "AND" function in lotus1-2-3 application
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.
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.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks