In Excel, how do you get it to not automatically round my dollars up or down.
Ex: I am summing a group of numbers and the total equals $598.6780. I want
to show only 2 decimal places but do NOT want Excel to round the amount up.
I want the answer to show me $598.67 not $598.68.
Assuming your $598.6780 value is in A1
In B1 type:
=TRUNC(A1,2)
to get $598.67
OR
If your $598.6780 was arrived at as the result of a formula enclose that formula in the TRUNC function with the ,2 after your formula.
eg. =TRUNC((your formula),2)
Last edited by Cutter; 01-07-2005 at 04:45 PM.
One way
=ROUNDDOWN(A1,2)
Think you'll need the analysis toolpak add installed
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Cylie G." <Cylie G.@discussions.microsoft.com> wrote in message
news:63CDCD2E-5089-40EA-A2AE-E0891DE5FBC3@microsoft.com...
> In Excel, how do you get it to not automatically round my dollars up or
down.
>
> Ex: I am summing a group of numbers and the total equals $598.6780. I
want
> to show only 2 decimal places but do NOT want Excel to round the amount
up.
> I want the answer to show me $598.67 not $598.68.
>
=TRUNC(A1,2) might be what you're looking for
"Cylie G." wrote:
> In Excel, how do you get it to not automatically round my dollars up or down.
>
> Ex: I am summing a group of numbers and the total equals $598.6780. I want
> to show only 2 decimal places but do NOT want Excel to round the amount up.
> I want the answer to show me $598.67 not $598.68.
>
=TRUNC(A1,2) might be what you're looking for
"Cylie G." wrote:
> In Excel, how do you get it to not automatically round my dollars up or down.
>
> Ex: I am summing a group of numbers and the total equals $598.6780. I want
> to show only 2 decimal places but do NOT want Excel to round the amount up.
> I want the answer to show me $598.67 not $598.68.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks