|
HOW TO TREAT NEG NUMBERS AS ZEROS?
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
__________________
Achilles
-----Being unable to assume an initial premise with any tolerable degree of accuracy, I am loathe to assert a conclusion, fearful lest I should err.
|
