Forum Discussion

User278's avatar
User278
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, 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.

2 Replies

Resources