Thread: Need to create custom function of this formula
View Single Post
  #1   Report Post  
Dishant Rai Dishant Rai is offline
Junior Member
  
Posts: 1
Default Need to create custom function of this formula
Can someone create a custom user defined function for this formula

The only thing variable would be the range / array i.e. C8:C57

=IF(COUNT(C8:C57<6,"",IF(COUNT(C8:C57<6),"",IF(MOD ((50/100)*COUNT(C8:C57),1)0,SMALL(C8:C57,INT((50/100)*COUNT(C8:C57))+1),AVERAGE(SMALL(C8:C57,INT((5 0/100)*COUNT(C8:C57))),SMALL(C8:C57,INT((50/100)*COUNT(C8:C57))+1)))))
Reply With QuoteReply With Quote