LinkBack URL
About LinkBacks
Hi guys,
How can i get best 3 out of 5 value and add up the best 3 value? ive try "=IF(C103="","",SUM(K5,K25,K45,K65,K85)-MIN(K5,K25,K45,K65,K85))" but it shown me 4 out of 5 best result. any kind soul can help this out for me?
Hi guys,
How can i get best 3 out of 5 value and add up the best 3 value? ive try "=IF(C103="","",SUM(K5,K25,K45,K65,K85)-MIN(K5,K25,K45,K65,K85))" but it shown me 4 out of 5 best result. any kind soul can help this out for me?
Last edited by Zervyn; 04-09-2012 at 03:14 AM.
What does "best" mean? Smallest, roundest, nicest looking?
Oops.. Sorry. I refer to highest score.
Hello Zervyn,
This should work.
Please Login or Register to view this content.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Thank you Haseeb A! you solve my problem. =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks