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

excel if isna vlookupshortcut for tick mark in exceldiv error in excelformulas and functions in excel 2007data matching in excelclassroom tools name pickermacro creation in excelhow to create a macro in excelbell curve template excel 2010excel vlookup if statementbasic vlookup exampleuniform distribution excelstudent assignment sheet templateprobability graph excelhow to avoid duplicates in excelhow to make a percentage bar graph in excelexcel macro nested ifcorrect tick symbolexcel template for tracking tasksrandomizer excelhow to use vlookup to compare two columnsexcel finding duplicatesvba excel samplescheduling template for excelif function in excel 2007 with exampleexcel deduplicationisna in excelvlookup two columns matchstack bar graphhow do you remove duplicate rows in excelexcel pivot table count distincthow to use hlookuph look uphistogram chart in excelexcel spreadsheet formula cheat sheetsort duplicates in excelcareer ucla edudownloadable excel calendartick icon wordphilip tengexcel remove headerp&l format in excelhow to remove duplicate rowsmicrosoft excel query tutorialexcel cell formatinghow to use transpose in excel 2007count excel formulav look excelremove duplicates excel 2010random name generator to pick winnerbell chart in excelvlookup true falseexcel return cell referenceexcel if function multiple conditionshomework schedule templatewhat is a nested function in excelexcel eliminate duplicate rowshow to build an excel macroexcel histogramsbasic formulas of excelfc seoul jerseymixing formulas togetherrandbetween no duplicatesformatting options in excelcount formula for excelformula of vlookup in excel with exampleexcel formulas tutorialfiltering two columns in exceldeleting duplicates excelhow to draw column graph in excelif statements in excel with texthistograms in excel 2010converting from excel to pdfhomework sheet templateexample for vlookup in excelremove formula in excelexcel format percentage in formula