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

examples for vlookup in excelexcel stdev ifexcel compare to columnscompare two columns in excel 2010sumif and matchhighlight duplicate cells in excelrandom number generator excel no repeatsmba for dummiesh lookup in excelexcel formula to find duplicatesstudent pickervlookup different sheetsexcel delete duplicate linessimple bar graph in excelhow to put a title on excel graphirs underpayment penaltyshortcut key for pivot table in excel 2007excel vlookups and pivot tablesgantt chart format excelexcel formula max lengthexcel planning calendar templateexcel table formulasucla parking enforcementexcel vlookup tableconvert decimal to whole number in excelexcel ranges in formulaspadfolio interviewhorizontal analysis excelexcel how to delete duplicate rowsexcel database lookupucla gear cheappre mba internship consultingexcel stacked bar chartwhat is hlookup in excelsort remove duplicatesvertical lookup excelucla gpa requirementsexcel vlookup compare two columnsexcel array formula vlookupbin range histogramround to the nearest million in excelsort ascending in excelvlookup excel 2007 tutorialhlookup excel formulahow do i get a tick in exceliferror and vlookupvlookup vs hlookupexcel drag formulaformula for count in excelexcel vba application.matchwhat is the tick symbol in wordvlookup example 2013how to remove pivot table but keep datahow to use if condition in excel 2007excel offset functionaccounts payable uclavlookup with truevlookup practice exerciseshow to create a bar chart in excel 2010vlookup column and rowfuzzy matching excelmr excel formulasexcel graph barhow to get rid of na in vlookupnormally distributed random numbersexcel multiple lookupadvanced vlookup excelhow to run sensitivity analysis in excelw 4 worksheet calculatordecimal point in excelfilter out duplicates in excelstacked columns in excelsg&a calculationhow to do a checkmark in excel 2010how to insert symbol in excelucla ticket office universal studiosexcel function vlookupis there a way to remove duplicates in excelgenerate random names in excelif statement excel examples