(Msg. 1) Posted: Fri Nov 06, 2009 1:38 am
Post subject: Round Off Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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
(Msg. 2) Posted: Fri Nov 06, 2009 1:57 am
Post subject: RE: Round Off [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
"Fareez" wrote:
> 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
>
(Msg. 3) Posted: Fri Nov 06, 2009 2:00 am
Post subject: Re: Round Off [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
or use Number format with 0 decimal places...
On 6 Lis, 10:57, Mike H <Mi....DeleteThis@discussions.microsoft.com> wrote:
> 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
>
>
>
> "Fareez" wrote:
> > 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- Ukryj cytowany tekst -
>
> - Pokaż cytowany tekst -
(Msg. 4) Posted: Fri Nov 06, 2009 2:11 am
Post subject: RE: Round Off [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Instead of rounding that off; click on 'Decrease the decimals' from
'Formatting toolbar' which will change the format...
If this post helps click Yes
---------------
Jacob Skaria
"Fareez" wrote:
> 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
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office