Forum Discussion
Solved
Roundup
I am able to round up eg. 1.2 roundup to 2 and 0.9 roundup to 1. But I can't find out what to do is that if their a -number change to 0 or leave blank. eg. -0.3 to 0 or -1.6 to 0. I keep getting-0.3 t...
- easiest is probably to enclose it in a MAX(...,0) since any negative number is <0 then MAX will take the 0 instead.
easiest is probably to enclose it in a MAX(...,0) since any negative number is <0 then MAX will take the 0 instead.
Sorry for late reply... this is the fourmla I used...
=CEILING.MATH(R22>0)*ROUNDUP(R22,0)
this rounded up the numbers above 0 to the next highest number eg 1.3 up to 2 and negative numbers to 0 eg -1.3 or -4.9 to 0
=CEILING.MATH(R22>0)*ROUNDUP(R22,0)
this rounded up the numbers above 0 to the next highest number eg 1.3 up to 2 and negative numbers to 0 eg -1.3 or -4.9 to 0