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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
 Hot
 Latest

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

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

How To: Create a passfail grade formula in Microsoft Excel

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

How To: Calculate APR, EAR & period rates in Microsoft Excel 2010

How To: Enter formulas in Excel with a macro

How To: Create a Tangent Line with Excel

How To: Create an Excel inventory template with running totals

How To: Graph the probability density function in an Excel file

How To: Create a relative frequency distribution in MS Excel

How To: Display trend arrows in a Microsoft Excel spreadsheet

How To: Create a checkbookbalancing formula in Excel

How To: Completely hide the Ribbon menu in Excel

How To: Calculate future value for a sinking fund in MS Excel

How To: Format numbers to display exponents in Microsoft Excel

How To: Scan a document in Word 2007

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

How To: Create an Excel spreadsheet to calculate your GPA

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

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

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

How To: Create a passfail grade formula in Microsoft Excel

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

How To: Calculate APR, EAR & period rates in Microsoft Excel 2010

How To: Enter formulas in Excel with a macro

How To: Create a Tangent Line with Excel

How To: Create an Excel inventory template with running totals

How To: Graph the probability density function in an Excel file

How To: Create a relative frequency distribution in MS Excel

How To: Display trend arrows in a Microsoft Excel spreadsheet

How To: Create a checkbookbalancing formula in Excel

How To: Completely hide the Ribbon menu in Excel

How To: Calculate future value for a sinking fund in MS Excel

How To: Scan a document in Word 2007

How To: Format numbers to display exponents in Microsoft Excel

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

How To: Create an Excel spreadsheet to calculate your GPA

How To: Clear data & cell contents in Excel using a macro
1 Comment
I want bonus formula...I want calculate with salary
Share Your Thoughts