Oct 21 2019 02:23 PM
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?
Oct 21 2019 04:43 PM
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,
Oct 22 2019 12:02 PM
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.