Col1 Col2 Col2 col4 Result
4 4 4 4 T
4 4 1 1 F
1 4 3 4 T
2 4 1 3 F
2 4 3 3 T
I want to compare above 4 columns and get result as T or F as per following condition.
Condition 1
If cell value is 3 or 4 and
Condition 2
3 out of 4 should be fulfilled condition1 then result is T otherwise F.
Please help me to resolve this. If you need further details please let me know.
Cheers
Sama
Hi
Try
rylo
Please Login or Register to view this content.
try this formula in cell A5 assuming you have your 4 data in cells A1 to A4.
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
try this....
=IF(COUNTIF(A2:D2,">="&3)>=3,"T","F")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
or maybe this one.
=IF(OR(COUNTIF(A1:D1,3)>2,COUNTIF(A1:D1,4)>2),TRUE,FALSE)Condition 2
3 out of 4 should be fulfilled condition1 then result is T otherwise F.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks