Forum Discussion

JustasG's avatar
JustasG
Copper Contributor
Dec 23, 2024

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?
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 23, 2024

Perhaps

=IF(A1 < 1, ROUND(A1,0), ROUNDUP(A1,0) )
m_tarler's avatar
m_tarler
Bronze Contributor
Dec 23, 2024

Alternatively:

=IF( A1<0.5, 0, ROUNDUP(A1,0) )

 

Resources