Need to find a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-924843%22%20slang%3D%22en-US%22%3ENeed%20to%20find%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-924843%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20grades%20that%20are%20in%20text%20format%20as%20Pass%20or%20Fail.%26nbsp%3B%20My%20instructor%20wants%20me%20to%20use%20a%20formula%20to%20determine%20whether%20or%20not%20the%20average%20grade%20is%20a%20passing%20one%20based%20on%20the%20one%20column.%26nbsp%3B%20What%20formula%20would%20I%20use%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-924843%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-925482%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20find%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-925482%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F430472%22%20target%3D%22_blank%22%3E%40Mczar240%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20best%20function%20to%20use%20is%20IF%20function.%20In%20the%20attached%20picture%2C%20I%20created%20a%20similar%20data%20and%20used%20IF%20function%20to%20return%20with%20pass%20or%20fail%20based%20on%20the%20cut-off%20mark.%20Kindly%20let%20me%20know%20if%20this%20is%20helpful%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-927790%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20find%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927790%22%20slang%3D%22en-US%22%3E%3CP%3EHI!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20the%20help.%26nbsp%3B%20I%20had%20been%20looking%20through%20all%20of%20the%20different%20IF%20functions%20and%20eventually%20figured%20out%20that%20the%20formula%20was%20supposed%20to%20be%20based%20on%20the%20number%20grade.%26nbsp%3B%20The%20text%20is%20written%20in%20a%20bit%20of%20a%20confusing%20way%20but%20it%20got%20sorted%20out.%26nbsp%3B%20I%20also%20decided%20to%20purchase%20a%20book%20that%20has%20all%20formulas%20for%20the%20excel%20program.%26nbsp%3B%20I%20found%20it%20on%20amazon%20and%20it%20got%20excellent%20reviews.%26nbsp%3B%20I%20hope%20that%20it%20helps%20in%20the%20future.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-927800%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20find%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927800%22%20slang%3D%22en-US%22%3EYou're%20welcome%20friend%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a column of grades that are in text format as Pass or Fail.  My instructor wants me to use a formula to determine whether or not the average grade is a passing one based on the one column.  What formula would I use?

3 Replies
Highlighted

Hello@Mczar240 

 

The best function to use is IF function. In the attached picture, I created a similar data and used IF function to return with pass or fail based on the cut-off mark. Kindly let me know if this is helpful

 

Regards,

 

Highlighted

HI!@Abiola1 

 

Thank you so much for the help.  I had been looking through all of the different IF functions and eventually figured out that the formula was supposed to be based on the number grade.  The text is written in a bit of a confusing way but it got sorted out.  I also decided to purchase a book that has all formulas for the excel program.  I found it on amazon and it got excellent reviews.  I hope that it helps in the future.  

Highlighted
You're welcome friend