Home

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
Mczar240
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

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,

 

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.  

You're welcome friend
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies