Forum Discussion
User278
Nov 16, 2020Copper Contributor
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, necesito ayuda con una fórmula que redondee si el número es mayor a 6 y que redondee hacia abajo si el número es menor a 6.
Ya intenté con
=SI(D3>6, REDONDEAR.MENOS, REDONDEAR)
Y devuelve error, ayuda por favor.
How about this?
=IF(D3<6, ROUNDDOWN(D3,0), ROUND(D3,0) )
2 Replies
How about this?
=IF(D3<6, ROUNDDOWN(D3,0), ROUND(D3,0) )
- User278Copper ContributorThanks!
Love u