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: Enter formulas in Excel with a macro

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

How To: Create an Excel inventory template with running totals

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

How To: Extract records that meet certain criteria in Excel

How To: Create a percentage frequency table in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Find range and interquartile range in Microsoft Excel

How To: Calculate probability in an Excel pivot table

How To: Turn off AutoCorrect symbols in Excel

How To: Change the operator in formula from dropdown in Excel

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

How To: Cross tabulate categorical data in Microsoft Excel

How To: Build a 15minute schedule in Microsoft Excel

How To: Calculate proportions and percentages in Excel

How To: Do bank reconciliation in Microsoft Excel

How To: Create a dynamic weekly chart in Microsoft Excel

How To: Extract part of a table from a larger table in Excel

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Enter formulas in Excel with a macro

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

How To: Create an Excel inventory template with running totals

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

How To: Extract records that meet certain criteria in Excel

How To: Create a percentage frequency table in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Find range and interquartile range in Microsoft Excel

How To: Calculate probability in an Excel pivot table

How To: Turn off AutoCorrect symbols in Excel

How To: Change the operator in formula from dropdown in Excel

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

How To: Cross tabulate categorical data in Microsoft Excel

How To: Build a 15minute schedule in Microsoft Excel

How To: Calculate proportions and percentages in Excel

How To: Do bank reconciliation in Microsoft Excel

How To: Create a dynamic weekly chart in Microsoft Excel

How To: Extract part of a table from a larger table in Excel
1 Comment
I want bonus formula...I want calculate with salary
Share Your Thoughts