Hello all,
Apologies if this is not possible but I have the following situation:
<tbody>
</tbody>
<tbody>
</tbody>I would like to round up each of these cells to the closest number but also so that they match the total in column I?
If you do this with the standard =ROUND function you will get 43, 157, 247, 210, 133, 71 and a total of 861.
So this is forcing me to go back and manually change the 43.44559 to be rounded up to 44 (as it's the closest to being rounded up out of the lot).
Is there any way to make this process automatic in a formula?
Thank you in advance.
Apologies if this is not possible but I have the following situation:
C | D | E | F | G | H | I (Total) |
43.44559 | 156.9966 | 246.8499 | 210.3162 | 133.299 | 71.09278 | 862 |
<tbody>
</tbody>
<tbody>
</tbody>
If you do this with the standard =ROUND function you will get 43, 157, 247, 210, 133, 71 and a total of 861.
So this is forcing me to go back and manually change the 43.44559 to be rounded up to 44 (as it's the closest to being rounded up out of the lot).
Is there any way to make this process automatic in a formula?
Thank you in advance.