Formulas & Functions

IF Function

IF function Use the IF function to return one value if a condition is true and another value if it’s false. Syntax IF(logical_test, value_if_true, [value_if_false]) example: =IF(A2>B2,“Over Budget”,“OK”) =IF(A4=500,B4-A4,“”) WORKBOOKS

Excel Is Fun

Excel Magic Trick 1190

Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for [Read More >>>]

Dueling Excel

Dueling Excel 58

Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales [Read More >>>]

Dueling Excel

Dueling Excel 57

Extract Many Years from Just Two Years DESCRIPTION See Mr Excel and excelisfun take the text string “1997-2000” and create a row of years consisting of 1997, 1998, 1999, 2000. See the functions LEFT, RIGHT, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1165

Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Functions DESCRIPTION See how to Add 4 Tests Scores, But Substitute Final Score If Greater Than Low Test Score using the IF, MIN [Read More >>>]

Excel Is Fun

Excel Magic Trick 1155

IF Function: Checking For Empty Cells (5 Methods) DESCRIPTION IF Function: Checking For Empty Cell & Zero Length Text Strings: (00:08) Problem Setup (00:56) IF function logical test using Zero Length Text String (checks for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1154

Unique Count:Name & Date & Criteria From 3rd Column (3 Methods) DESCRIPTION See how to Unique Count For Name & Date & Criteria From 3rd Column: (00:08) Problem Setup (00:50) Array Formula. Learn about IF [Read More >>>]

Excel Is Fun

Excel Magic Trick 1153

Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… DESCRIPTION See how to: (00:08) Problem Set Up (00:55) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula (02:38) Remove [Read More >>>]