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.
Just updated your iPhone to iOS 18? You'll find a ton of hot new features for some of your most-used Apple apps. Dive in and see for yourself:
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Conditionally format at every change in value in Excel
How To:
Create a Tangent Line with Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Do matrix multiplication and inverse in MS Excel
How To:
Use VLOOKUP across worksheets in MS Excel 2007
How To:
Find a P-Value with Excel
How To:
Create a multiuser login system in Microsoft Access
How To:
Hide scroll bars, sheet tabs & charts in Excel
How To:
Find critical values with T functions in MS Excel
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Calculate bonuses based on years worked in MS Excel
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Insert and format a text box in Microsoft Word for Mac 2011
How To:
Calculate YTM and effective annual yield from bond cash flows in Excel
How To:
Add drawings and free-form shapes in MS Word 2007
How To:
Multiply column times row with Transpose in MS Excel
How To:
Create a checkbook-balancing formula in Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Conditionally format at every change in value in Excel
How To:
Create a Tangent Line with Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Do matrix multiplication and inverse in MS Excel
How To:
Use VLOOKUP across worksheets in MS Excel 2007
How To:
Find a P-Value with Excel
How To:
Create a multiuser login system in Microsoft Access
How To:
Find critical values with T functions in MS Excel
How To:
Hide scroll bars, sheet tabs & charts in Excel
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Insert and format a text box in Microsoft Word for Mac 2011
How To:
Calculate YTM and effective annual yield from bond cash flows in Excel
How To:
Calculate bonuses based on years worked in MS Excel
How To:
Add drawings and free-form shapes in MS Word 2007
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Type a bomb symbol in Microsoft Word
How To:
Work with math equations in Microsoft Excel 2010
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