Hi all,
Here is my issue, I have this formula, and I think there is something wrong with it coz it’s not giving me the result I need.
What I want to accomplish is IF in the selected cells, all the values are the same (Pass) the overall result will be “PASS” or we can say “PASS” is overall DEFAULT score. Next is, IF by any chance one cell has a value of “Maybe”, then the overall score will change to “MAYBE”. Another scenario is when the value of one of the cells is “Fail” The overall score will automatically be “FAILED” though one cell is selected as “Maybe”. “ Fail” overrides the overall result. Last scenario is that ALL cells has a value of “Pass” BUT if cell I55 is “Exceed” then the overall score will be “EXCEED”.<o></o>
<o> </o>
In short, the rule is by default the overall score is “PASS” but if one of the cells is MAYBE then the overall score will be “MAYBE”.<o></o>
But if in any cell there is a value of “FAIL” the overall score will be “FAIL”<o></o>
“EXCEED” will only happen if the value in each cell is “PASS”.<o></o>
You cannot exceed if you have a value of “maybe” and “fail”.<o></o>
<o> </o>
This is my formula and am stuck! I don’t know where to put “exceed”<o></o>
<o> </o>
{=IF(OR(I6,I15,I21,I25,I30,I36,I49,I52="Fail"),"FAIL",IF(OR(I6,I15,I21,I25,I30,I36,I49,I52="Maybe"),"MAYBE","PASS"))}<o></o>
<o> </o>
Thanks for the help!!!<o></o>
Here is my issue, I have this formula, and I think there is something wrong with it coz it’s not giving me the result I need.
What I want to accomplish is IF in the selected cells, all the values are the same (Pass) the overall result will be “PASS” or we can say “PASS” is overall DEFAULT score. Next is, IF by any chance one cell has a value of “Maybe”, then the overall score will change to “MAYBE”. Another scenario is when the value of one of the cells is “Fail” The overall score will automatically be “FAILED” though one cell is selected as “Maybe”. “ Fail” overrides the overall result. Last scenario is that ALL cells has a value of “Pass” BUT if cell I55 is “Exceed” then the overall score will be “EXCEED”.<o></o>
<o> </o>
In short, the rule is by default the overall score is “PASS” but if one of the cells is MAYBE then the overall score will be “MAYBE”.<o></o>
But if in any cell there is a value of “FAIL” the overall score will be “FAIL”<o></o>
“EXCEED” will only happen if the value in each cell is “PASS”.<o></o>
You cannot exceed if you have a value of “maybe” and “fail”.<o></o>
<o> </o>
This is my formula and am stuck! I don’t know where to put “exceed”<o></o>
<o> </o>
{=IF(OR(I6,I15,I21,I25,I30,I36,I49,I52="Fail"),"FAIL",IF(OR(I6,I15,I21,I25,I30,I36,I49,I52="Maybe"),"MAYBE","PASS"))}<o></o>
<o> </o>
Thanks for the help!!!<o></o>