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.