New to Microsoft Excel? Looking for a tip? How about a tip so mindblowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!
 Hot
 Latest

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Generate random numbers (with decimals) in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Create a percentage frequency table in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Enter formulas in Excel with a macro

How To: Extract records that meet certain criteria in Excel

How To: Create a simple database in Excel with a list or table

How To: Build a 15minute schedule in Microsoft Excel

How To: Update inventory records by formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Create a Tangent Line with Excel

How To: Clear data & cell contents in Excel using a macro

How To: Calculate geometric average in Excel with GEOMEAN

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

How To: Group duplicates & extract unique records in MS Excel

How To: Repeat a list of names 7 times in Excel

How To: Create a passfail grade formula in Microsoft Excel

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Generate random numbers (with decimals) in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Create a percentage frequency table in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Enter formulas in Excel with a macro

How To: Extract records that meet certain criteria in Excel

How To: Create a simple database in Excel with a list or table

How To: Build a 15minute schedule in Microsoft Excel

How To: Update inventory records by formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Create a Tangent Line with Excel

How To: Clear data & cell contents in Excel using a macro

How To: Calculate geometric average in Excel with GEOMEAN

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

How To: Group duplicates & extract unique records in MS Excel

How To: Repeat a list of names 7 times in Excel

How To: Create a passfail grade formula in Microsoft Excel
Be the First to Comment
Share Your Thoughts