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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks