how to return random non zero value to a particular cell?
=SUM(A1:A12)
--
David Biddulph
"Oligo" wrote in message
...
A
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00872500
0.00000000
assuming the non zero valu(0.008725) might fall in any row. how can i get
that value into cell B1?
|