Home > Topics > excel > What is the return value of function min seventeen twelve zero in excel?

What is the return value of function min seventeen twelve zero in excel?

烟雨青岚
Release: 2020-06-23 16:13:11
Original
13546 people have browsed it

What is the return value of function min seventeen twelve zero in excel?

What is the return value of function min seventeen twelve zero in excel?

The return value of function min seventeen twelve zero in excel is zero.

MIN function is a formula in Microsoft Excel, which can be expressed as min(x,y)=0.5*(x y-|x-y|)

Function: Returns the given Minimum value in parameter table.

Function parameters can be numbers, blank cells, logical values, or text strings representing numerical values. If there are incorrect values ​​in the parameters or text that cannot be converted into numerical values, an error will occur.

Syntax:

##MIN(number1,number2, ...)

[A,B]=MIN( number1,number2,...)

Parameters:

Parameters can be numbers, blank cells, logical values, or text strings representing numerical values. If there are incorrect values ​​in the parameters or literals that cannot be converted into numeric values, an error will occur.

If the argument is an array or reference, the function MIN only uses the numbers, blank cells in the array, or reference; logical values, literals, or error values ​​are ignored. If logical values ​​and literal strings cannot be ignored, use the MINA function.

If the parameter does not contain a number, the function MIN returns 0.

Recommended tutorial: "

excel tutorial"

The above is the detailed content of What is the return value of function min seventeen twelve zero in excel?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template