Need formula to check values

March 7, 2010 at 18:36:11
Specs: Windows XP
If a student get 35,40,50,25 marks he is failed because he get 25 marks in one subject. How to create a program in ms excel

See More: Need formula to check values

Report •


#1
March 7, 2010 at 19:57:39
To do what? You haven't given is enough information.

I have moved this to MS Office as it is more appropriate then Windows XP forum it was in

Stuart


Report •

#2
March 8, 2010 at 01:55:40
It seems the problem is (a) if the average is less than some value
or (b) if a single value is less than another value then student has
failed course.

Report •

#3
March 8, 2010 at 05:33:22
Assuming following set up:

      A    B    C    D
 1   35   40   50    25


Try this:

=IF(OR(A1<26,B1<26,C1<26,D1<26),"Fail","Pass")


Report •

Related Solutions

#4
March 8, 2010 at 06:05:46
Thank you,
really i received what i want

Report •

#5
March 8, 2010 at 13:44:44
Hi,

or this:

=IF(MIN(A1:D1)<26,"Fail","Pass")

Regards


Report •

Ask Question