QUARTILE takes two arguments, thearraycontaining numeric data to analyze, andquart, indicating which quartile value to return.
The QUARTILE function accepts 5 values for thequartargument, as shown in the table below.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
MAX Function
The Excel MAX function returns the largest numeric value in the data provided.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
For example, =MEDIAN(1,2,3,4,5) returns 3.
