IF Function between blank cell
i have excel worksheet like this
HTML Code:
i want to fill cell D3, D6, D9 automatically by a formula with condition if one lesson
is fail then it's fail, but if both lesson is success then it's success
example on cell D3 (blank cell on row for student name "Bob") should be fail (his math is fail),
same with cell D9 (blank cell on row for student name "jake", due to his biology is fail), but on cell D6 (blank cell on row for student name "jane") should be success
Last edited by abduldedysubhansyah; 12-13-2013 at 04:32 AM.
=IF(B1<>"","",IF(COUNTIFS($A$1:$A$9,A1,$C$1:$C$9,"fail")>0,"fail","success"))
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Another way.....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Originally Posted by RobertMika
i use the first method, but the second way also working as well,
this is just exactly what i need, a huge thanks for all
Glad to help you.
Meanwhile you may click on * (star) to Add Reputation for those why have put their time and efforts to help you in this forum and mark your thread as solved.
done for both of you.....thanks...
Thanks for the feedback and the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks