Round Off

[Fareez]

A B
7.5 8
8.2 8
9.5 10
3.7 4
7.4 7
7.7 8
Total 44 45
Please refer above example
I have some figures in column "A" it shold be rounded off , done in column
"B" what I want is aftrer rounding off toal increase by 1. that is before
round off total 44 ,after rounding off total 45. is there any way to round
off without affecting total. total sld remain unchanged

 

[Mike H]

Hi,

Using rounding I would say it is impossible to do what you want because it
changes the underlying value but you can do it with a format

In B1 enter
=A1
Drag down
In the new column enter a custom format of 0 for all the cells and they will
appear as you require but the underlying value won't have changed.

Mike

 

[Jarek Kujawa]

or use Number format with 0 decimal places...

Hi,

Using rounding I would say it is impossible to do what you want because it
changes the underlying value but you can do it with a format

In B1 enter
=A1
Drag down
In the new column enter a custom format of 0 for all the cells and they will
appear as you require but the underlying value won't have changed.

Mike





- Pokaż cytowany tekst -

 

[Jacob Skaria]

Instead of rounding that off; click on 'Decrease the decimals' from
'Formatting toolbar' which will change the format...

If this post helps click Yes