Re: spread*** computation

From: A N Niel (anniel_at_nym.alias.net.invalid)
Date: 10/01/04 

Date: Fri, 01 Oct 2004 16:25:26 -0400

In article <_Wh7d.76144$6h7.1447@twister.rdc-kc.rr.com>, Mohan Pawar <Reply@sciMathOnly.org> wrote:

> Copy following suggested formula and paste it in any appropriate cell. A
> better method is to write UDF( user defined function)
>
> =IF(COUNT(D:D)>6,
> LARGE(D:D,6)+LARGE(D:D,5)+LARGE(D:D,4)+LARGE(D:D,3)+LARGE(D:D,2)+LARGE(D:D,1
> ), SUM(D:D))

Thanks, I'll try it.

Quantcast