how about MAX(data series), and 0.8 times your max and then MIN(0.8*max-your data series).
回複:如何用excel算出一列數中大小排80%的數字
所有跟帖:
•
thanks, but that is a series of random number
-cloudate-
♂
(0 bytes)
()
08/19/2009 postreply
13:25:20
•
回複:thanks, but that is a series of random number
-nanochip-
♂
(227 bytes)
()
08/20/2009 postreply
15:32:06