H
hirendra7158
Hello!.
I am a teacher and I have column formed of Roll nos from 1 to 250 of my
students.
I mark their presence in B column by marking p .
I want to asertain in column C if the a particular cell B2 contains p
or not.
How do I proceed with If funcion?
because when I use the following formula
=if B1='p',1,0.
then error is turned up saying #name?
Please help.
Also How do I calculate individual student's total presence ?
Thank.
I am a teacher and I have column formed of Roll nos from 1 to 250 of my
students.
I mark their presence in B column by marking p .
I want to asertain in column C if the a particular cell B2 contains p
or not.
How do I proceed with If funcion?
because when I use the following formula
=if B1='p',1,0.
then error is turned up saying #name?
Please help.
Also How do I calculate individual student's total presence ?
Thank.