In this video on MAX Excel Function, here we discuss the MAX Formula in excel and how to use MAX Excel function along with excel example.๐๐๐ ๐ ๐ฎ๐ง๐๐ญ๐ข๐จ๐ง ๐ข๐ง ๐๐ฑ๐๐๐ฅ
-------------------------------------------
The function of Excel MAX is classified in Microsoft Excel under statistical functions.
To find out the maximum value from a given set of data / array, the Excel MAX Formula is used.
In Excel, the MAX function returns the largest value from a number set.
๐๐๐ ๐๐ฑ๐๐๐ฅ ๐ ๐จ๐ซ๐ฆ๐ฎ๐ฅ๐
--------------------------------------
=MAX (number 1, [number 2], ...)
MAX formula in excel has at least one mandatory parameter, i.e. number 1 and rest subsequent numbers are optional.
๐๐ซ๐ ๐ฎ๐ฆ๐๐ง๐ญ๐ฌ
----------------------
Compulsory Parameter
number1 - It's a number required.
Optional Parameter
[number2 - Remaining subsequent numbers are optional.
๐๐ก๐ข๐ง๐ ๐ฌ ๐ญ๐จ ๐๐๐ฆ๐๐ฆ๐๐๐ซ ๐ฐ๐ก๐ข๐ฅ๐ ๐ฎ๐ฌ๐ข๐ง๐ ๐๐๐ ๐๐ฑ๐๐๐ฅ ๐ ๐ฎ๐ง๐๐ญ๐ข๐จ๐ง
------------------------------------------------------------------------------------------------
#1 - MAX function through VALUE! Error if any of the supplied values are non-numeric.
#2 - Excel's MAX function counts numbers but ignores empty cells, text, TRUE and FALSE logical values, and text values.
#3 - If there are no arguments for the MAX function, it returns the 0 as output.
To know more about ๐๐๐ ๐๐ฑ๐๐๐ฅ ๐ ๐ฎ๐ง๐๐ญ๐ข๐จ๐ง, you can go to this ๐ฅ๐ข๐ง๐ค ๐ก๐๐ซ๐:-
Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe -
ะัะทัะบะฐ
ะคะธะปัะผั
ะขะ ะจะพั
ะะฐัะตะณะพัะธะธ ะฒะธะดะตะพ
