is there a way to have a column round automatically instead of having to round onto another column? I don't want to add another column to just be able to round.
is there a way to have a column round automatically instead of having to round onto another column? I don't want to add another column to just be able to round.
If the column contains formulas, the formulas can incorporate the Round()
function within themselves.
For example, if the formula is:
=A1*B1
it could be revised to:
=ROUND(A1*B1,2)
Is this what you're looking for?
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"denhar" <[email protected]> wrote in
message news:[email protected]...
>
> is there a way to have a column round automatically instead of having to
> round onto another column? I don't want to add another column to just
> be able to round.
>
>
> --
> denhar
> ------------------------------------------------------------------------
> denhar's Profile:
http://www.excelforum.com/member.php...o&userid=24089
> View this thread: http://www.excelforum.com/showthread...hreadid=378356
>
What formulas are you using to perform the rounding?
Just a thought ... Are you rounding ... OR ... formatting?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" <[email protected]> wrote in message
news:[email protected]...
> If the column contains formulas, the formulas can incorporate the Round()
> function within themselves.
>
> For example, if the formula is:
>
> =A1*B1
>
> it could be revised to:
>
> =ROUND(A1*B1,2)
>
> Is this what you're looking for?
> --
> HTH,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "denhar" <[email protected]> wrote in
> message news:[email protected]...
> >
> > is there a way to have a column round automatically instead of having to
> > round onto another column? I don't want to add another column to just
> > be able to round.
> >
> >
> > --
> > denhar
> > ------------------------------------------------------------------------
> > denhar's Profile:
> http://www.excelforum.com/member.php...o&userid=24089
> > View this thread:
http://www.excelforum.com/showthread...hreadid=378356
> >
>
Darn it - Wrong Thread !!!
"Ragdyer" <[email protected]> wrote in message
news:[email protected]...
> What formulas are you using to perform the rounding?
>
> Just a thought ... Are you rounding ... OR ... formatting?
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "Ragdyer" <[email protected]> wrote in message
> news:[email protected]...
> > If the column contains formulas, the formulas can incorporate the
Round()
> > function within themselves.
> >
> > For example, if the formula is:
> >
> > =A1*B1
> >
> > it could be revised to:
> >
> > =ROUND(A1*B1,2)
> >
> > Is this what you're looking for?
> > --
> > HTH,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
> -
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
> -
> > "denhar" <[email protected]> wrote in
> > message news:[email protected]...
> > >
> > > is there a way to have a column round automatically instead of having
to
> > > round onto another column? I don't want to add another column to just
> > > be able to round.
> > >
> > >
> > > --
> > > denhar
> >
> ------------------------------------------------------------------------
> > > denhar's Profile:
> > http://www.excelforum.com/member.php...o&userid=24089
> > > View this thread:
> http://www.excelforum.com/showthread...hreadid=378356
> > >
> >
>
as dumb as this sounds, sometimes I really would like to be able to put in $1.49 and it automatically change to $1 or $1.51 to $2. I have a long list of numbers to enter from a bunch of sources so having to stop and decipher takes too long. If I tell the column to not use decimal places which accomplishes the same thing only it doesn't give me the .00 that I need at the end.
If I understand you correctly, here are some thoughts . . .
First, use a custom format on your input cells:
Format>Cells>Number
Category: Custom
Type: 0".00"
That will make the numbers look like they are rounded to the nearest digit, but will still display 2 decimal places.
However...If you the sum of those cells to behave as if all of the values ARE rounded, you'll need a different kind of SUM function.
(Since they will contain the actual inputs (1.51 will look like 2.00, but will still be 1.51)
Try this for your totals (assuming inputs are in A1:A10):
=SUMPRODUCT(ROUND(A1:A10,0))
That function sums the rounded numbers.
Does that help?
Ron
I will try that - thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks