Nested IF statements are the thorn is the side of many Excel users. They can become long complex formula that are difficult to both read and write.
However, if you have been using Excel 365 one of the new functions available is IFS. Now this function is also available in Excel 2019 Standalone as a core function.
The IFS function can be used to replace this complex nested IF statements in many cases. Its syntax is simple
=IFS(Logical test 1, Value if true 1, Logical test 2, Value if true 2…..)
In this video you will learn how to use Excel Nested IF Statements and the newer IFS function to replace nested IF statements
Read the full post here
http://theexcelclub.com/nested-if-statements-replaced-with-ifs-function/
The Excel Club Blog is now Powered by #steem
▶️ DTube
▶️ IPFS