J
Jo1lygrngiant
Hi all, newbie on here, and wondering if anyone can help me please.
The problem is, im working on a ssheet for exam questions. The problem
being, i want to write a =if function, along the lines of if B1 has a x
in the cell, then make a seperate cell ie D1 total 1, else make the
total 0.
If that makes sense lol, only thing is, i have some 40+ exam papers I
need to do, and im looking for easier ways of marking them, instead of
going through each question, and putting a 1 in the box, if its
correct, then add that to the master sheet.
I've not used excel in many years, and used to be pretty good with it,
but ive lost the knack
Any help given, would be most appreciated!!, Many Many thanks in
advance
Nige
The problem is, im working on a ssheet for exam questions. The problem
being, i want to write a =if function, along the lines of if B1 has a x
in the cell, then make a seperate cell ie D1 total 1, else make the
total 0.
If that makes sense lol, only thing is, i have some 40+ exam papers I
need to do, and im looking for easier ways of marking them, instead of
going through each question, and putting a 1 in the box, if its
correct, then add that to the master sheet.
I've not used excel in many years, and used to be pretty good with it,
but ive lost the knack
Any help given, would be most appreciated!!, Many Many thanks in
advance
Nige