Hello all,
kindly help
i am making result card of students in ms excel.
i need to add marks obtained and total marks
but
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 )
{
sum English+History+Mathematics+Chemistry+Physics+Computer
}
%answer is 520 %
else if (comp == 0)
{
sum English+History+Mathematics+Chemistry+Physics+Biology
}
%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' )
{
sum English+History+Mathematics+Chemistry+Physics+Computer
}
else if (Bio == 'A')
{
sum English+History+Mathematics+Chemistry+Physics+Biology
}
waiting for a favourable response
Bookmarks