Are you using nested If functions? It's time to use IFS for those nested functions. You can use up to 127 pairs of conditions in IFS function.
IFS(logical test1,value if true1,[logical test2,value if true2],[logical test3,value if true3]............)
logical test1 - This is the first condition. This is an required input for the function.
value if true1 - Result if first condition true. This is also required input.
logical test2 - The second condition. This is an optional input
value if true2 - Result if seconed condition true. This is an optional input
.
.
.
upto 127
If you need to return default value if any of the conditions not meet, enter a condition that always true ("1=1") and enter the default value as result.
Check below dataset
Re-enter column A values to yoour workbook or download the sample file here. Enter below to all cells in column B
=IFS(A2>90,"A+",A2>75,"A",A2>65,"B",A2>55,"C",A2>40,"S",A2>30,"W",1=1,"F")c Here we used 1=1 as always true condition and "F" as default result.
You can see cell B2 showing F because 30 is not within any condition. All others shows the values according to the conditions on the function.
You can discover more about this function from Microsoft Office Help.
