So I have the following cells:
1 0.2
-2 0
Assuming the second line is row E, I used =MAX(0,E2/5) to round my negative results to zero. I also want to add to this formula and use it on all of my values so that positive numbers will be rounded up. For example above, assuming the first row is D, I would like the answer to be 1 instead of 0.2 (the result of =MAX(0,D2/5). I want it to be
=ROUNDUP(D2/5,0), which would equal 1.
How can I combine these to work together to round my negative values to zero, but also round my positive numbers up?
Sorry if this is confusing, as I am an excel amateur.
Pete
Bookmarks