hi,
i have this basic project of a class of students where i need to gather information in regards to exam results. Using an if statement i've managed to assign each student a grade (A+ to D) but now need to log the number of failures and the percentage failed in a separate cell. My guess is it involves another if statement but i'm unsure as to how i might code this. I've tried stuff like 'IF Final Result = 'D' etc but i seem to be a little way off & i'm new to excel.
thx for any replies....
i have this basic project of a class of students where i need to gather information in regards to exam results. Using an if statement i've managed to assign each student a grade (A+ to D) but now need to log the number of failures and the percentage failed in a separate cell. My guess is it involves another if statement but i'm unsure as to how i might code this. I've tried stuff like 'IF Final Result = 'D' etc but i seem to be a little way off & i'm new to excel.
thx for any replies....