Formulas and Functions
এই নিয়ন্ত্রণ পরিবর্তন করলে এই পেজটি স্বয়ংক্রিয়ভাবে আপডেট হবে

MAX

The MAX function returns the largest numeric value in a set of number values, date/time values or duration values.

To learn the basics about using formulas and functions, see Formulas overview and Functions overview.

MAX(value, value…)

value: Any value or collection containing any values. Date/time values or duration values can’t be mixed with other value types. If either of these value types is included, all values must be of the same value type. A string value or Boolean value can be included in a referenced cell, but can’t be entered directly as an argument to the function.

value…: Optionally include one or more additional values or collections.

Notes

  • A string value or Boolean value included in a referenced cell is not considered in determining which value is the maximum value.

Examples

=MAX(5, 5, 5, 5, 6) returns 6.

=MAX(1, 2, 3, 4, 5) returns 5.

See alsoLARGEMAXAMINSMALLAdd and edit formulasReview formula errors and follow best practicesRefer to cells in formulas
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
কাজে লেগেছে?
অক্ষর সীমা: 250
সর্বাধিক অক্ষর সীমা 250।
আপনার মতামতের জন্য ধন্যবাদ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.