Forum Discussion

Copper Contributor

Nov 16, 2020

Solved

I need help with a formula

I need a formula that rounds down if the number is less than six and rounds if the number is greater than six. I already tryied with =IF(D3>=6, ROUND, ROUNDDOWN) And results in error. Hola,...

excel

Wyn Hopkins
Nov 16, 2020
How about this?

=IF(D3<6, ROUNDDOWN(D3,0), ROUND(D3,0) )

Wyn Hopkins

MVP

Nov 16, 2020

How about this?

=IF(D3<6, ROUNDDOWN(D3,0), ROUND(D3,0) )

User278

Copper Contributor

Nov 16, 2020

Thanks!
Love u