Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Qestion to judge whether the candidate has passed or failed ......
Qestion to judge whether the candidate has passed or failed depending upon
the marks secured in different subjects. my question is that to compare marks scored by the person in different subject and if the marks scored by that person in any one of that person is less than 40 i have to get "F" in grade coloumn else i have to get "P" in that coloumn. Hope that u got that u got my question. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Qestion to judge whether the candidate has passed or failed ......
Lets enter the gardes in column A from A2 thru A100. In another cell enter:
=IF(MIN(A2:A100)<40,"F","P") adjust the range to suit your needs. -- Gary''s Student - gsnu200791 "Neelakanta" wrote: Qestion to judge whether the candidate has passed or failed depending upon the marks secured in different subjects. my question is that to compare marks scored by the person in different subject and if the marks scored by that person in any one of that person is less than 40 i have to get "F" in grade coloumn else i have to get "P" in that coloumn. Hope that u got that u got my question. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Qestion to judge whether the candidate has passed or failed ..
ur method worked but, i can't understand how did it caluculate?
MIN(a1:a100) returns the value which is minimum in that cell range. isn't it? and if that is less than 40........... ????? i can't understand the logic. can u please explain me? Thanks in advance. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Qestion to judge whether the candidate has passed or failed ..
Here is the thinking behind the approach:
We want to know if ANY of the grades are below 40. So let's look at the lowest grade. MIN() gives us the lowest grade. If that grade is below 40, then the candidate fails. We don't need to consider any of the person's other grades. -- Gary''s Student - gsnu200791 "Neelakanta" wrote: ur method worked but, i can't understand how did it caluculate? MIN(a1:a100) returns the value which is minimum in that cell range. isn't it? and if that is less than 40........... ????? i can't understand the logic. can u please explain me? Thanks in advance. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Qestion to judge whether the candidate has passed or failed ..
You have the patience of a Saint Gary!
"Gary''s Student" wrote in message ... Here is the thinking behind the approach: We want to know if ANY of the grades are below 40. So let's look at the lowest grade. MIN() gives us the lowest grade. If that grade is below 40, then the candidate fails. We don't need to consider any of the person's other grades. -- Gary''s Student - gsnu200791 "Neelakanta" wrote: ur method worked but, i can't understand how did it caluculate? MIN(a1:a100) returns the value which is minimum in that cell range. isn't it? and if that is less than 40........... ????? i can't understand the logic. can u please explain me? Thanks in advance. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Qestion to judge whether the candidate has passed or failed ..
Thank you!
-- Gary''s Student - gsnu200791 "Robert McCurdy" wrote: You have the patience of a Saint Gary! "Gary''s Student" wrote in message ... Here is the thinking behind the approach: We want to know if ANY of the grades are below 40. So let's look at the lowest grade. MIN() gives us the lowest grade. If that grade is below 40, then the candidate fails. We don't need to consider any of the person's other grades. -- Gary''s Student - gsnu200791 "Neelakanta" wrote: ur method worked but, i can't understand how did it caluculate? MIN(a1:a100) returns the value which is minimum in that cell range. isn't it? and if that is less than 40........... ????? i can't understand the logic. can u please explain me? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I fix a forecast date that has passed for a zero value? | Excel Discussion (Misc queries) | |||
Tricky qestion about pasting cells with formulas | Excel Discussion (Misc queries) | |||
Date Passed Notification | Excel Discussion (Misc queries) | |||
how do i work out how many hrs have passed in a 24 hr clock, in ex | Excel Worksheet Functions | |||
ClearContents method on a passed range | New Users to Excel |