Answer 1 out of 1
 
22 helpful answers
A:


I know my method is not “clean” but it works: let’s say your column of numbers is column A. Write in box B1 the following argument: “=IF(A1>0,0,A1)” now just drag it down to the point A ends, and it will do the math for you (it works the same with rows).

 
Comment About This Answer (or add your own answer)

Feed - Subscribe to changes to this Q&A Blog
ADVERTISEMENT
ADVERTISEMENT
AOL Autos Q&A is powered by Yedda an AOL Company
Copyright © 2006-2009, Yedda Inc. and respective copyright owners