I've been searching a few different threads, and I've tried all the solutions posted but nothing seems to work.
So far the main answer for this question seems to be something like this: '=IF(Average(1, "A", IF(Average(2, "B", IF(Average(3, "C", IF(Average(4, "D", "Fail")))))))) - but this doesn't work.
I'm very new to formulas, I'm just trying to teach myself some new things to make working a bit more efficient.
Any help much appreciated.
Bookmarks