- Picture and text skills
- Case
Returns the maximum value in a set of values.
Syntax
MAX(number1,number2,...)
Number1, number2, ... are 1 to 30 numeric parameters from which the maximum value is to be found.
Description
• You can specify arguments as numbers, blank cells, logical values, or text expressions of numbers.
If the argument is an incorrect value or text that cannot be converted to a number, an error will be generated.
• If the parameter is an array or reference, Then only the numbers in the array or reference will be evaluated.
Blank cells, logical values, or text in arrays or references will be ignored. If logical values and text cannot be ignored, use the MAXA function instead.
• If the argument does not contain a number, the function MAX returns 0 (zero).
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/qiao-yong-MAX-han-shu-yi-miao-zhao-dao-zui-da-shu-zhi.html
支付宝扫一扫 
评论列表（196条）
测试