Formulas and Functions
ह्या कंट्रोलमध्ये बदल केल्यामुळे हे पेज ऑटोमॅटिकली अपडेट होईल

AND

The AND function returns the Boolean value TRUE if all arguments are true, and the Boolean value FALSE otherwise.

AND(test-expression, test-expression…)

test-expression: An expression. test-expression can contain anything as long as the expression can be evaluated as a Boolean value. If the expression evaluates to a number, 0 is considered to be FALSE, and any other number is considered to be TRUE.

test-expression…: Optionally include one or more additional expressions.

Notes

  • The AND function is equivalent to the logical conjunction operator used in mathematics or logic. It first evaluates each test-expression. If all the given expressions evaluate to the Boolean value TRUE, the AND function returns the Boolean value TRUE; otherwise the Boolean value FALSE.

Examples

=AND(TRUE,TRUE) returns TRUE because both arguments are true.

=AND(1, 0, 1, 1) returns FALSE because one of the arguments is a numeric 0, which is interpreted as FALSE.

=AND(A5>60, A5<=100) returns TRUE if cell A5 contains a number greater than 60 and less than or equal to 100; otherwise FALSE.

The following two IF functions return the same value:

=IF(A5>60, IF(A5<=100, TRUE, FALSE), FALSE) returns TRUE, assuming cell A5 contains 75, or any other value greater than 60 and less than or equal to 100.

=IF(AND(A5>60, A5<=100), TRUE, FALSE) also returns TRUE.

See alsoIFNOTOR
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
उपयुक्त आहे का?
कॅरॅक्टर मर्यादा : 250
कमाल कॅरॅक्टर मर्यादा 250 आहे.
तुमच्या प्रतिक्रियेबद्दल धन्यवाद.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.