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