End Function in Excel

This function tests two or more conditions to see if they are all true.

It can be used to test that a series of numbers meet certain conditions.
It can be used to test that a number or a date falls between an upper and lower limit.

Note :- 
1. Returns TRUE if all its arguments evaluate to TRUE.
2. Returns FALSE if one or more arguments evaluate to FALSE

=And(Logical1,Logical2,.......)



=AND(TRUE,TRUE)       =      TRUE
=AND(TRUE,FALSE)      =      FALSE









Popular posts from this blog

Comments