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,...
  • Wyn Hopkins's avatar
    Nov 16, 2020

    How about this?

     

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

Resources