{"id":1900,"date":"2018-03-25T09:02:24","date_gmt":"2018-03-25T03:02:24","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1282"},"modified":"2018-03-25T09:02:24","modified_gmt":"2018-03-25T03:02:24","slug":"ifs-and-ifna-to-avoid-nested-ifs","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1900","title":{"rendered":"IFS (and IFNA) to avoid nested IFs"},"content":{"rendered":"

I tend to see more and more the usage of nested IF functions recently<\/p>\n

Now, do not get me wrong, IF is great, but come on, are you going to use it for more than 2 conditions? seriously?<\/p>\n

Excel 2013 comes with IFS, the perfect alternative to nested IFs<\/p>\n

As you can see, takes up to 127 conditions, neat, right?<\/p>\n

<\/p>\n

\"\"<\/a><\/p>\n

As you can see, it basically goes as …<\/p>\n

If condition1 from Logical_test1<\/strong><\/em> is true, then display value from Value_if_true1<\/strong><\/em><\/p>\n

If not…<\/p>\n

Then if condition from Logical_test2<\/strong><\/em> is true, then display value from Value_if_true2<\/strong><\/em><\/p>\n

if not…<\/p>\n

Then if condition from Logical_test3<\/strong><\/em> is true, then display value from Value_if_true3<\/strong><\/em><\/p>\n

and so on, until last condition.<\/p>\n

Please, make use of that if you know your spreadsheet will not be used in Excel 2010, which I understand is still in the market.<\/p>\n

Anyways, screenshots here are from my cell phone while i was playing with IFS<\/p>\n

Oh, and of course, if you want to catch the condition of none of these are true, just use IFNA, or you can use IF(ISERROR( too.<\/p>\n

give it a shot!<\/p>\n