On 2002-04-19 12:26, jasono wrote:
Does anybody know how to use the MIN formula and EXCLUDE the value of 0?
I have a column that when a user enters a value, a zero can be the end result. I want it to display the lowest value other than 0.
Thank you,
Jason
On 2002-04-19 12:51, jasono wrote:
Number 1 Number 2
Enter your numbers >>>>>> 77777 889
GCD>>> 77777 889
889 434
434 21
21 14
14 7
7 0
0 0
0 0
0 0
0 0
0 0
0 0 is>>>>
Here is what the spread sheet looks like. In this case I would need to return a value of 7. In other cases the final number might be in any column on the left. MIN returns the lowest value which is 0.
This message was edited by jasono on 2002-04-19 12:52
On 2002-04-19 12:51, jasono wrote:
Number 1 Number 2
Enter your numbers >>>>>> 77777 889
GCD>>> 77777 889
889 434
434 21
21 14
14 7
7 0
0 0
0 0
0 0
0 0
0 0
0 0 is>>>>
Here is what the spread sheet looks like. In this case I would need to return a value of 7. In other cases the final number might be in any column on the left. MIN returns the lowest value which is 0.
This message was edited by jasono on 2002-04-19 12:52