Formulas & Functions

IF Function

February 14, 2016 0

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

Dueling Excel

Dueling Excel 63

February 10, 2016 0

2 Criteria Lookup and Multiple Table Lookup From Different Sheets DESCRIPTION See Mr Excel and excelisfun do a 2 Criteria Lookup and Multiple Table Lookup From Different Sheets. Amazing Lookup Solution that: 1. Uses functions […]

Excel Is Fun

Excel Magic Trick 1191

February 8, 2016 0

VLOOKUP: Lookup Temperature and Return to Bat Observation Table DESCRIPTION In this example we have Date Set 1 with Bat Observation Date-Times and we need to lookup the Date-Time in a second Data Set with […]

Dueling Excel

Dueling Excel 62

February 3, 2016 0

Conditional Format Chart Auto Feature or Formula DESCRIPTION See Mr Excel & excelisfun Conditional Format a Chart: 1) Excel 2010 with an automatic feature 2) Formula Method Format Columns where quality rating is greater than […]

Excel Is Fun

Excel Magic Trick 1190

February 1, 2016 0

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 […]

Dueling Excel

Dueling Excel 61

January 27, 2016 0

Formula To Report Cell Reference 5 Examples DESCRIPTION See Mr Excel and excelisfun create five formulas that can retrieve a cell reference. See the functions: MATCH, ROW, ADDRESS, COLUMN, CELL, and SUBSTITUTE, and the Ampersand […]

Excel Is Fun

Excel Magic Trick 1189

January 25, 2016 0

Extract Color From Description Create Revenue by Color PivotTable, 2nd Take DESCRIPTION See how extract color from description, but only when the color is a single word with a space before and after the word. […]