Forum Discussion

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 23, 2024

Re: IF with round and round up

Perhaps

=IF(A1 < 1, ROUND(A1,0), ROUNDUP(A1,0) )

1 Reply

  • m_tarler's avatar
    m_tarler
    Silver Contributor
    Dec 23, 2024

    Alternatively:

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