I want cells that have formulas to treat every value above 0, as a value of 0. How do I do that?
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).
Got an answer for commondiablo? Would you like to comment on the posted answers, or vote for the one which you think is the best?
Sign up for a free account, or sign in (if you're already a member).
Other people asked questions on similar topics, check out the answers they received:
Other people asked questions on various topics, and are still waiting for answer. Would be great if you can take a sec and answer them
