I am using roundup function in one column of cells in excel. In the next column of cells, i just need to subtract the values from the previous column. But when I use it in the next cell, I want it to take the cell value or the rounded up value but it is still taking the original value...How to avoid this?

Need some guidance to solve this.

Example:

*I have put here an example. Fix it and delete this line when you're done, leaving the example*

```
| A | B | C
-----------+--------+--------------+-----------------
formulas: | | =ROUND(A1;3) | =IF(...;A1;B1)
values: | 0,5715 | 0,572 | 0,5715
-----------+--------+--------------+-----------------
```

This is my situation:

Value for first row is =ROUND(O7*1000,1) and value for second row is =J8-J7.

The image is

You can see that in the 3 row 2 column, the value should be 74, but it is 73. How to change this?

simulatethe roundup by setting the appropriate number of decimals in the field format? Then you wouldn't need the rounding. Otherwise, you could put the answer in a hidden cell/column, and in the visible one place`=ROUND(hidden_addr)`

. You'd be free to usehidden_addrin the new column. – LSerni Oct 6 '13 at 20:45orthe rounded up value"? You want the new cell to assume a valueinstead ofanother, based on some condition? Might then not the error be in the condition itself? – LSerni Oct 6 '13 at 21:14