LinkBack URL
About LinkBacks
Hello Friends,
In the attached sheet I want to show the result in the form of Pass,Fail and Supplementary. I am able to make the result pass or fail but could not able to use 3 rd condition. Please help..........
Hello Friends,
In the attached sheet I want to show the result in the form of Pass,Fail and Supplementary. I am able to make the result pass or fail but could not able to use 3 rd condition. Please help..........
Last edited by lokpal.panwar; 03-12-2013 at 04:57 AM.
Perhaps in I3 and copy down?
=IF(SUM(J3:N3)=5,"Pass",IF(SUM(J3:N3)>=3,"supplemendery","Fail"))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
hi lokpal.panwar, welcome to the forum. put this in row 3 & copy down:
=IF(COUNTIF(C3:G3,">=33")=5,"Pass",IF(COUNTIF(C3:G3,"<33")<=2,"Supplementary","Fail"))
is that what you need? you can then do away with column J onwards
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks Fottis
Hi Benishiryo,
Mentioned formula looks right to me but when i applied it gave wrong result. Why this happened ???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks