Thank you for your interest!
I have the following table:
In order to pass this class, (Grade1 + Grade2)/2>86 and Grade3>70 and either "YES" or "NO" should appear under the Pass Column (E)
All of the functions I have tried with =IF and =AND or such have failed, I have a feeling I am not placing the "(" and ")" right, not being in the right order/ combination.....
Can you please help me sort this out?
A few ideas on how to do it?
I have managed to solve half of it, if (Grade1 + Grade2)/2>86 then "yes" or "no", but I cannot understand how to do the rest....
Bookmarks