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?
=ROUND(hidden_addr)
. You'd be free to use hidden_addr in the new column. – LSerni Oct 6 '13 at 20:45