how do I add round to a IF statement

  • Thread starter Kelly Ditsworth
  • Start date
P

Pete_UK

Why not add this to the end of your other thread, rather than start a
new one? People reading this will not have a clue what this refers to.

Anyway, a function cannot change the value in a different cell, so you
will need to put the ROUND( ) function in cell C8 if that is the one
you need to change. If C8 is a cell where you enter data, then the
data will over-ride the formula. Perhaps you can use Data Validation
on that cell to restrict it to the number of decimal places or integer
values that you wish.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top