Forum Discussion
JustasG
Dec 23, 2024Copper Contributor
IF with round and round up
Hi, I am trying to create formula that would use round if values is less than 1 and if more than 1 would use roundup. Is there any ideas is that is possible?
SergeiBaklan
Dec 24, 2024Diamond Contributor
Or
=CEILING(A1-(A1<1)/2,1)