Page 20 - Code Craft Computer-7

MIN(range or values) It returns the smallest number from the given range.
Consider these values:
A1:56, A2:34, A3: 78, A4:41, A5:90

=MIN(A1:A5)
Result: 34

MAX(range or values) It returns the largest number from the given range.
Consider these values:
A1:56, A2:34, A3: 78, A4:41, A5:90

=MAX(A1:A5)
Result: 90

FORMULA ERRORS
In Excel, if any formula is entered incorrectly, then Excel displays an error message rather than
the proper value. It also assists you in identifying and fixing the problem. Some of the common

errors along with their possible reasons are listed here.

This error occurs if the column
#### Error
does not have enough space
to accommodate the value.

It occurs if incorrect formula
#NAME? Error
is used.

It occurs if the formula contains
#VALUE! Error
an invalid argument.

This error occurs if the number
#DIV/0! Error
is divided by zero or an empty

cell.

20