Ifs for adding functions in Excel 2016

Ifs for adding functions in Excel 2016

 

In the January 2016 feature update, Excel 2016 added several important common functions, including ifs, switch, maxifs, minifs, Concat, and textjoin.

Note: To use the above functions, the Office version is very important, not all office 2016 can be used. Suggestions

InHttps://products.office.com/zh-CN/tryTry Office 365 and install the latest version of Office 2016.

You can also install it online through the Office 365 installer. Installer:

Http://down.51cto.com/data/2250280

 

The IFS function checks whether one or more conditions are met and returns the value corresponding to the first true condition. Ifs can replace multiple nested if statements and can be read more easily through multiple conditions.

Syntax:

Ifs ([condition 1, value 1, [condition 2, value 2,],… [Condition 127, value 127,])

1. the IFS function allows you to test a maximum of 127 different conditions. Note the order in which the conditions are written;

2. to specify the default result, enter a condition that is always true for the "condition" parameter, such as true or 1 = 1. If no other conditions are met, the corresponding value is returned. In example 1, rows 6 and 7 (with a score of 58) show this result;

3. If the "condition" parameter is provided without a corresponding "value", this function will display a typical error message "you have entered too few parameters for this function;

4. If the "condition" parameter is parsed to a value other than true or false, this function returns # value! Error;

5. If the true condition is not found, this function returns # N/! Error.

 

Example:

The score is used to determine the score level.

= Ifs (B2> 89, "A", B2> 79, "B", B2> 69, "C", B2> 59, "D", B2> = 0, "D", true, "score input error ")

In the formula, the condition must be written before 89, that is, pay attention to the writing order of the condition. The final condition "true" indicates the default result after all the preceding conditions meet.

 

650) This. width = 650; "src =" http://s4.51cto.com/wyfs02/M01/88/F2/wKiom1gB2JSgUUKWAADJRWEDp4U392.jpg-wh_500x0-wm_3-wmp_4-s_2088378091.jpg "Title =" 0026.jpg "alt =" wkiom1gb2jsguukwaadjrwedp4u392.jpg-wh_50 "/>

 

This article is from the "Start from the Heart" blog. For more information, contact the author!

Ifs for adding functions in Excel 2016