title: How to ROUNDUP and ROUNDDOWN with IF-function
body: <p>I'm trying to make a number round up or round down depending on if it's higher or lower than 05..</p>
  <p>If the number in <code>A1</code> is for example 73,
  I want cell <code>B1</code> to round UP to 75.</p>
  <p>If the number in <code>A1</code> is 78 I want <code>B1</code> to round DOWN to 75.</p>
  <p>So if I type a number between 50-54 it rounds up, and if I type a number between 56-59 it rounds down, and so on.</p>
  <p>I have tried different functions for rounding up and down, but the only result I get is either a regular round up, or a regular round down.
  I can't figure out how to make it work both ways depending on what number I type.</p>
  <p>I think I have to use <code>=IF</code> in some way, but can't figure out how.</p>
  <p>This is my latest try.. and I'm lost!
  <code>IF=A1&lt;85;(ROUND.UP(A1;5(IF(A1&gt;85;(ROUND.DOWN(A1;5)))))))</code></p>
  <p>and I want it to round up and down not only between 80-89.. so even if my formula had been working it would only work for 80-89, and that's not what I'm trying to do.</p>
  <p>Any suggestions?</p>
  <p>Best regards, J</p>