New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pass-fail grading formula using the IF and AND and VLOOKUP functions.
Follow WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Enter formulas in Excel with a macro
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Create a bond discount or premium amortization table in Excel
How To:
Create a line chart mapping blood pressure in MS Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Cross tabulate categorical data in Microsoft Excel
How To:
Summarize survey results with a pivot table in Excel
How To:
Create confidence intervals for proportions in Excel
How To:
Check your voicemail in Microsoft Outlook
How To:
Create a simple database in Excel with a list or table
How To:
Calculate monthly retirement income in Microsoft Excel
How To:
Calculate vacation days with TODAY, YEAR & IF in Excel
How To:
Repeat a list of names 7 times in Excel
How To:
Use the Format Cells dialog box in MS Excel 2007
How To:
Create an Excel pivot table with 4-variable tabulation
How To:
Insert movie files into a MS Word document
How To:
Use table styles in Microsoft Word for Mac 2011
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Enter formulas in Excel with a macro
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Create a bond discount or premium amortization table in Excel
How To:
Create a line chart mapping blood pressure in MS Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Cross tabulate categorical data in Microsoft Excel
How To:
Summarize survey results with a pivot table in Excel
How To:
Create confidence intervals for proportions in Excel
How To:
Check your voicemail in Microsoft Outlook
How To:
Create a simple database in Excel with a list or table
How To:
Calculate monthly retirement income in Microsoft Excel
How To:
Calculate vacation days with TODAY, YEAR & IF in Excel
How To:
Repeat a list of names 7 times in Excel
How To:
Use the Format Cells dialog box in MS Excel 2007
How To:
Create an Excel pivot table with 4-variable tabulation
How To:
Insert movie files into a MS Word document
How To:
Use table styles in Microsoft Word for Mac 2011
4 Comments
That was amazing! Thanks so much for that!
please send me Class position formula in excel with result card?
sir how to make an auto grading in microsoft word table
this is what i am using in excel but it did not work in microsoft word.
=IF(C2<=39,"E",IF(C2<=59,"D",IF(C2<=69,"C",IF(C2<=84,"B","A"))))
help me please
You can also use vlookup table. Create a grade table and use vlookup to retrieve the grade of given score.
Share Your Thoughts