kernelx
09-09-2013, 03:23 PM
I have a combine marks sheet of 10 students. some of the student was absent on paper day so I marked them "A" 9absent in the sheet. now I want to equalize the value of A=0 . as it has some impact on average value. i am posting two snapes to clear my point;
http://imagesup.net/?di=14137872151211
http://imagesup.net/?di=1113787215771
Here If I put the value "A" in "4F" average will be "51.13 % in "18F" but if I replace "A" by "0" then average will be "45.44" . I want to show "A" in cell but it value should be considered as "0" in average formula. kindly help...
http://imagesup.net/?di=14137872151211
http://imagesup.net/?di=1113787215771
Here If I put the value "A" in "4F" average will be "51.13 % in "18F" but if I replace "A" by "0" then average will be "45.44" . I want to show "A" in cell but it value should be considered as "0" in average formula. kindly help...