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.