Roundup

[Norman_Glenn]

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 to -1 and -1.6 to -2. Iv attached a photo below showing my table and fourmla I'm trying to use

[#2 · Accepted solution]

easiest is probably to enclose it in a MAX(...,0) since any negative number is <0 then MAX will take the 0 instead.

[#3]

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