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: Generate random numbers (with decimals) in Excel

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

How To: Build a 15minute schedule in Microsoft Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Make an Excel gradebook that drops the 2 lowest scores

How To: Find critical values with T functions in MS Excel

How To: Create a multiuser login system in Microsoft Access

How To: Score a Full Version of Microsoft Office for Only $10

How To: Turn off AutoCorrect symbols in Excel

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

How To: Pull data from a master sheet in Microsoft Excel

How To: Put your MS Access databases on your website

How To: Calculate a bonus in Microsoft Excel

How To: Create a Tangent Line with Excel

How To: Calculate expected return with an Excel array formula

How To: Run queries from forms in Microsoft Access

How To: Calculate future & present value for multiple cash flows in Excel

How To: Automatically highlight negative numbers in MS Excel

How To: Navigate worksheets in Microsoft Excel 2007

How To: Find a PValue with 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: Build a 15minute schedule in Microsoft Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Make an Excel gradebook that drops the 2 lowest scores

How To: Find critical values with T functions in MS Excel

How To: Create a multiuser login system in Microsoft Access

How To: Score a Full Version of Microsoft Office for Only $10

How To: Turn off AutoCorrect symbols in Excel

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

How To: Pull data from a master sheet in Microsoft Excel

How To: Put your MS Access databases on your website

How To: Calculate a bonus in Microsoft Excel

How To: Create a Tangent Line with Excel

How To: Calculate expected return with an Excel array formula

How To: Run queries from forms in Microsoft Access

How To: Calculate future & present value for multiple cash flows in Excel

How To: Automatically highlight negative numbers in MS Excel

How To: Navigate worksheets in Microsoft Excel 2007
1 Comment
I want bonus formula...I want calculate with salary
Share Your Thoughts