IF Statements

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 >>
When writing a series of VLOOKUP formulas, one of the annoying things is having to see the "#N/A" error after Excel has determined a lookup value is not available.  While we don't want to show any values when they are truly unavailable, from a visual design perspective, it's sometimes better just to show a blank space ... Continue Reading >>

Related pages

pretty excel chartsexcel highlight duplicate valuescheckmarks in excelvlookup formula with if conditionvba excel randomisna formula in excelhow to check duplicate records in excelcpk calculation excel downloadhow to make a bell curve in excel 2010segmented bar chartshow to calculate sg&acomplete excel formulasformatting excel cellsvlookup conditionrand in excelmyucla webmailcomplex vlookuplabel excel chartuniformly distributed random numbersexcel graph projectionvba match functionmatching columns in excelmicrosoft excel remove duplicatesrandom score generatorexcel shortcut paste special valueshistogram builderproblems with vlookupvlookup function examplenormal distribution histogram excelhow to create a bar graph in excel 2007create a histogram in excelvlooexcel formulas usingexcel repeat formuladuplicacy meaninghow to find duplicates in excel sheetif functions in excel 2010shortcuts to excelbest book on excelexcel fuzzy lookupexcel find duplicate values in columnformula filter excelmultiple if statements in one cellrandom sequence generator exceleliminate duplicatesexcel free trial 2007quick excel formulasexcel matching formuladelete duplicate rows excelexcel bar chart multiple seriesmicrosoft office 2013 30 day free trialexcel remove non duplicatesvlookup greater thancase statement in excel formulahow to merge duplicate rows in excelconditional statements in excelexcel vlookup offsetonline bell curve generatorexcel if statement with two conditionsoffset example excelp&l analysis exampleformatting graphs in excelvlookup valuemyuclausing vlookup on excelbuilding formulas in excelthe goal goldratt sparknoteszs associates consultingwhat is a boutique consulting firmexcel normal distribution probabilityleft vlookupexcel hotkeyhow to find out duplicate records in excelmyucla mailexcel if not blank