One of my readers ask me a homework question about Excel formulas in a recent article I posted on Nested IF statements. In his defense the problem seemed fairly simple, but you had to think carefully about the options and then know what Excel functions to use.The Problem
For three scores you get one grade: Failed, Passed or Honors. Any of the scores less than 60 gets you a failed score. All of the scores being 80 or above get you the Honors distinction. Otherwise you pass.The Solution
After I figure this out and post a reply another reader bested me handily, so I had to regroup and make another attempt. Here’s my solution.