On Sat, 12 Sep 2009 11:08:19 -0700 (PDT), sweetummy
wrote:

I have to caluculate 2500 students records which has 5 subjects marks
for 100 marks each.

my criteria is
1. Each subject should be 35 it should return PASS otherwise FAIL
2. There are some absenties (who has not written the exam) also..

3.we have 27 areas are divided into 5 regions. i have to retrieve the
information .

According to each area..like "City name" "number of passed " "
failed"

if(a235,"Pass","fail") succeded but its not possible to check if
(a2:a735"Pass","fail") .. please help..

you can download this file..

http://sites.google.com/site/gsvfilm...attredirects=0

Try this formula:

=IF(AND(A2:A735),"Pass","fail")

Note: This is an array formula that has to be confirmed with
CTRL+SHIFT+ENTER rather than just ENTER.

Hope this helps / Lars-Åke