Quote:
Originally Posted by Achilles
I would like to perform some arithmetical operations on a column of figures in EXCEL. How do I get the formula to treat any number which is less than zero in value, as if its value is zero?( i.e. if x<0, then x=0) I hope that someone here can help when they can. Thanks in advance................Jack
|
Sorry I missed this.
Very simple:
1. Column A is a column of values
10
20
0
-10
-20
50
2. Column B is created from column A using this formula:
=(A1>0) * A1