| | | 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. |
| | | Any empty cells, logical values, or text in the array or reference are ignored. |
| | | If the arguments contain no numbers, then 0 is returned. |
| | | You can have a maximum of 30 arguments. |
| | | If you do not want to include arguments that are text or logical values you can use the MAXA() function. |
| | | MAXIF() - Returns the maximum value in a range of values that match a certain condition. |