AND

Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.
Syntax
AND(logical1,logical2, ...)
Logical1, logical2, ...    are 1 to 30 conditions you want to test that can be either TRUE or FALSE.
Remarks

• The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays or references that contain logical values.
• If an array or reference argument contains text or empty cells, those values are ignored.
• If the specified range contains no logical values, AND returns the #VALUE! error value.

Example 1
The example may be easier to understand if you copy it to a blank worksheet.

	A	B
1	Formula	Description (Result)
2	=AND(TRUE, TRUE)	All arguments are TRUE (TRUE)
3	=AND(TRUE, FALSE)	One argument is FALSE (FALSE)
4	=AND(2+2=4, 2+3=5)	All arguments evaluate to TRUE (TRUE)

MIN

Returns the smallest number in a set of values.
Syntax
MIN(number1,number2,...)
Number1, number2, ...    are 1 to 30 numbers for which you want to find the minimum value.
Remarks

• You can specify arguments that are numbers, empty cells, logical values, or text representations of numbers. Arguments that are error values or text that cannot be translated into numbers cause errors.
• If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored. If logical values and text should not be ignored, use MINA instead.
• If the arguments contain no numbers, MIN returns 0.

Example