Maxa

Maxa

More

Home

Microsoft 365

Office

Windows

Surface

Xbox

Deals

All Microsoft

Microsoft 365

Teams

Windows

Surface

Xbox

Deals

Small Business

Support

Software
Software

Windows Apps

OneDrive

Outlook

Skype

OneNote

Microsoft Teams

Microsoft Edge

PCs & Devices
PCs & Devices

Computers

Shop Xbox

Accessories

VR & mixed reality

Phones

Entertainment
Entertainment

Xbox Game Pass Ultimate

PC Game Pass

Xbox games

PC games

Windows digital games

Movies & TV

Business
Business

Microsoft Cloud

Microsoft Security

Dynamics 365

Microsoft 365 for business

Microsoft Power Platform

Windows 365

Microsoft Industry

Small Business

Developer & IT
Developer & IT

Azure

Developer Center

Documentation

Microsoft Learn

Microsoft Tech Community

Azure Marketplace

AppSource

Visual Studio

Other
Other

Microsoft Rewards

Free downloads & security

Education

Virtual workshops and training

Gift cards

Holiday gifts

Licensing

Microsoft Experience Center

View Sitemap

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More... Less
You’re invited to try Microsoft 365 for free

Thank you! Any more feedback? (The more you tell us the more we can help.)

Can you help us improve? (The more you tell us the more we can help.)

Any additional feedback? (Optional)

English (United States)

Sitemap

Contact Microsoft

Privacy

Manage cookies

Terms of use

Trademarks

Safety & eco

About our ads

© Microsoft 2022

This article describes the formula syntax and usage of the MAXA function in Microsoft Excel.
Returns the largest value in a list of arguments.
MAXA is similar to MINA. For more information, see the examples for the MINA function .
The MAXA function syntax has the following arguments:

Value1    Required. The first number argument for which you want to find the largest value.

Value2,...    Optional. Number arguments 2 to 255 for which you want to find the largest value.
Arguments can be the following: numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference.
Logical values and text representations of numbers that you type directly into the list of arguments are counted.
If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
Arguments that are error values or text that cannot be translated into numbers cause errors.
Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
If the arguments contain no values, MAXA returns 0 (zero).
If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAX function.
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
The largest number in the range A2:A6. Because a TRUE value evaluates to 1, it is the largest.

More

Home

Microsoft 365

Office

Windows

Surface

Xbox

Deals

All Microsoft

Microsoft 365

Teams

Windows

Surface

Xbox

Deals

Small Business

Support

Software
Software

Windows Apps

OneDrive

Outlook

Skype

OneNote

Microsoft Teams

Microsoft Edge

PCs & Devices
PCs & Devices

Computers

Shop Xbox

Accessories

VR & mixed reality

Phones

Entertainment
Entertainment

Xbox Game Pass Ultimate

PC Game Pass

Xbox games

PC games

Windows digital games

Movies & TV

Business
Business

Microsoft Cloud

Microsoft Security

Dynamics 365

Microsoft 365 for business

Microsoft Power Platform

Windows 365

Microsoft Industry

Small Business

Developer & IT
Developer & IT

Azure

Developer Center

Documentation

Microsoft Learn

Microsoft Tech Community

Azure Marketplace

AppSource

Visual Studio

Other
Other

Microsoft Rewards

Free downloads & security

Education

Virtual workshops and training

Gift cards

Holiday gifts

Licensing

Microsoft Experience Center

View Sitemap

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More... Less
You’re invited to try Microsoft 365 for free

Thank you! Any more feedback? (The more you tell us the more we can help.)

Can you help us improve? (The more you tell us the more we can help.)

Any additional feedback? (Optional)

English (United States)

Sitemap

Contact Microsoft

Privacy

Manage cookies

Terms of use

Trademarks

Safety & eco

About our ads

© Microsoft 2022

This article describes the formula syntax and usage of the MAXA function in Microsoft Excel.
Returns the largest value in a list of arguments.
MAXA is similar to MINA. For more information, see the examples for the MINA function .
The MAXA function syntax has the following arguments:

Value1    Required. The first number argument for which you want to find the largest value.

Value2,...    Optional. Number arguments 2 to 255 for which you want to find the largest value.
Arguments can be the following: numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference.
Logical values and text representations of numbers that you type directly into the list of arguments are counted.
If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
Arguments that are error values or text that cannot be translated into numbers cause errors.
Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
If the arguments contain no values, MAXA returns 0 (zero).
If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAX function.
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
The largest number in the range A2:A6. Because a TRUE value evaluates to 1, it is the largest.

More

Home

Microsoft 365

Office

Windows

Surface

Xbox

Deals

All Microsoft

Microsoft 365

Teams

Windows

Surface

Xbox

Deals

Small Business

Support

Software
Software

Windows Apps

OneDrive

Outlook

Skype

OneNote

Microsoft Teams

Microsoft Edge

PCs & Devices
PCs & Devices

Computers

Shop Xbox

Accessories

VR & mixed reality

Phones

Entertainment
Entertainment

Xbox Game Pass Ultimate

PC Game Pass

Xbox games

PC games

Windows digital games

Movies & TV

Business
Business

Microsoft Cloud

Microsoft Security

Dynamics 365

Microsoft 365 for business

Microsoft Power Platform

Windows 365

Microsoft Industry

Small Business

Developer & IT
Developer & IT

Azure

Developer Center

Documentation

Microsoft Learn

Microsoft Tech Community

Azure Marketplace

AppSource

Visual Studio

Other
Other

Microsoft Rewards

Free downloads & security

Education

Virtual workshops and training

Gift cards

Holiday gifts

Licensing

Microsoft Experience Center

View Sitemap

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 20
Зрелые женщины голышом на природе
Худенькая милашка Milagres A принимает разные позы
Деловую Jessica Lynn завалили на стол и оттрахали в офисе

Maxa

Report Page