Assigning Points in a Weighted Scale (HELP!)

's Computer Specifications

I am trying to decode a complicated excel formula left to me by a former
colleague. Can someone help me decipher this?

=IF(F6="N/A",$Y$4,((IF(STANDARDIZE(F6,Mean Fresh_ret_rate,StdDev
Fresh_ret_rate)<0,(StdDevLow Fresh_ret_rate*-1)-(STANDARDIZE(F6,Mean
Fresh_ret_rate,StdDev Fresh_ret_rate)*-1),IF(STANDARDIZE(F6,Mean
Fresh_ret_rate,StdDev Fresh_ret_rate)>0,(StdDevLow
Fresh_ret_rate*-1)+STANDARDIZE(F6,Mean Fresh_ret_rate,StdDev
Fresh_ret_rate),0)))/StdDevRange Fresh_ret_rate)*Weight Fresh_ret_rate)

--
greatday007
------------------------------------------------------------------------
greatday007's Profile: http://www.excelforum.com/member.php...o&userid=36119
View this thread: http://www.excelforum.com/showthread...hreadid=558941

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning a points scoring system	zelus	Microsoft Excel Discussion	2	18th May 2006 03:07 AM
assigning points to rankings	=?Utf-8?B?TmFuLUM=?=	Microsoft Excel Worksheet Functions	9	15th Apr 2006 07:59 PM
Weighted Scale	=?Utf-8?B?V2hpcmx5?=	Microsoft Excel Charting	2	8th Aug 2005 02:59 PM
Linear spacing of points in log scale	Ron Cüppers	Microsoft Excel Discussion	4	28th Oct 2003 08:26 PM
Weighted color scale	Sophia	Microsoft Excel Charting	1	23rd Aug 2003 03:58 PM