- Picture and text skills
- Case
Returns the minimum value in the argument list. Text values and logical values (such as TRUE and FALSE) are also evaluated as numbers.
Grammar
MINA(value1,value2,...)
Value1, value2, ... are 1 to 30 parameters from which the minimum value needs to be found.
Description
• Parameters can be numbers, blank cells, logical values, or text expressions of numbers. If the parameter is an incorrect value, an error will be generated.
If you cannot include text or logical values in your calculations, use the MIN worksheet function instead.
• If the argument is an array or reference, only the numeric values are used. Blank cells and text values in arrays or references are ignored.
• Arguments containing TRUE are evaluated as 1; arguments containing text or FALSE are evaluated as 0.
• If the argument contains no value, function MINA returns 0.
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/MINA-han-shu-ji-suan-shu-zhi-de-zui-xiao-zhi.html
支付宝扫一扫 
评论列表（196条）
测试