![]() ![]() The basic translation of this formula is "If B5 is greater than C5 return B5. ![]() For example, in the example shown, the IF function could be used to return the larger of the two values like this: =IF(B5>C5,B5,C5) This means you can use MAX to solve a variety of "largest of" problems:Īs this example shows, the MAX function can be used as a compact and elegant replacement for the IF function. ![]() The MAX function can be used to return the largest value from any type of numeric data. This is the approach used in the worksheet shown, where the formula in E5 is: =MAX(B5,C5)Īs the formula is copied down, it returns the value in column B or the value in column C, whichever is larger. However, because MAX can accept values in separate arguments, you can easily use the MAX function to select the larger of values in two cells like this: =MAX(A1,B1) // larger of A1 or B1 In Excel, it's common to use the MAX function with a range like this: =MAX(range) // max value in range The MAX function returns the largest numeric value in the data provided. Although this problem could be solved with the IF function (see below), the simplest solution is to use the MAX function. In this example, the goal is to return the greater of two values which appear in columns B and C.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |