SOLVED

I need help with a formula

Copper Contributor

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
best response confirmed by User278 (Copper Contributor)
Solution

How about this?

 

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

Thanks!
Love u
1 best response

Accepted Solutions
best response confirmed by User278 (Copper Contributor)
Solution

How about this?

 

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

View solution in original post