technology for creative work |
|
||||||||||||
www.dtptools.com | |||||||||||||
ANDAND function returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE. The logical1 and logica2 conditions are required and you can optionally add up to 255 conditions.
SAMPLE: AND(A1=1,A2=2,A3=3)
will look like the following table, where 1 represents TRUE:
This table shows 0 in the formula result, because not all conditions are evaluated as true:
|
|||||||||||||
© 2004 - 2021 DTP Tools Ltd. All rights reserved. Legal Notices. Disclaimer. |