SOLVED

Roundup

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3146096%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ERoundup%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3146096%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EI%20am%20able%20to%20round%20up%20eg.%201.2%20roundup%20to%202%20and%200.9%20roundup%20to%201.%20But%20I%20can't%20find%20out%20what%20to%20do%20is%20that%20if%20their%20a%20-number%20change%20to%200%20or%20leave%20blank.%20eg.%20-0.3%20to%200%20or%20-1.6%20to%200.%20I%20keep%20getting-0.3%20to%20-1%20and%20-1.6%20to%20-2.%20Iv%20attached%20a%20photo%20below%20showing%20my%20table%20and%20fourmla%20I'm%20trying%20to%20use%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3146096%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3146123%22%20slang%3D%22en-US%22%3ERe%3A%20Roundup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3146123%22%20slang%3D%22en-US%22%3Eeasiest%20is%20probably%20to%20enclose%20it%20in%20a%20MAX(...%2C0)%20since%20any%20negative%20number%20is%20%26lt%3B0%20then%20MAX%20will%20take%20the%200%20instead.%3C%2FLINGO-BODY%3E
Contributor
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 Replies
best response confirmed by Norman_Glenn (Contributor)
Solution
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