nested if – MBA Excel

How to Write a Nested IF Statement in Excel

January 3, 2016December 31, 2015 by Matthew Kuo

Writing a Nested IF Statement is widely considered a rite of passage for beginning Excel users who are looking to become more advanced. The first time I used this technique was during my new employee training, right before I became a business analyst in management consulting. The overall concept of writing a Nested IF is ... Continue Reading >>

How to Use the Excel MATCH Formula to Assign Histogram Bins

January 3, 2016November 22, 2015 by Matthew Kuo

One of the most annoying things to have to do in Excel is writing a Nested IF statement. For those of you that haven't done this before, a Nested IF is basically a long formula with multiple IF conditions that you need to account for. The most common usage of this formula is to assign ... Continue Reading >>