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.Normally the AND() function would be used in conjunction with a function such as =IF().
=AND(Test1,Test2), like these 30 Tests can be done.
Example:
=AND(Test1,Test2), like these 30 Tests can be done.
Example:
No comments:
Post a Comment