Forum Discussion

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

3 Replies

SergeiBaklan
Diamond Contributor
Dec 24, 2024
Or

=CEILING(A1-(A1<1)/2,1)
SergeiBaklan
Diamond Contributor
Dec 23, 2024
Perhaps

=IF(A1 < 1, ROUND(A1,0), ROUNDUP(A1,0) )
- m_tarler
  Bronze Contributor
  Dec 23, 2024
  Alternatively:
  =IF( A1<0.5, 0, ROUNDUP(A1,0) )