i am making result card of students in ms excel.
i need to add marks obtained and total marks
there is a restriction
there are total 7 subjects with different total marks e.g.
English (100), History (100), Mathematics (85), Chemistry (85), Physics (75), Computer (75) and Biology (85).
Rest of subjects are compulsory for students except Biology and Computer
Those who attempt computer will not be attempting Biology and vice versa
so i need a formula to get total marks sum
example what i want
if ( bio == 0 )
%answer is 520 %
else if (comp == 0)
%answer is 530 %
%In case some is absent from computer or biology paper we need to add total of their respective subjects so %
else if ( Comp == 'A' )
else if (Bio == 'A')
waiting for a favourable response