I am using $ #'s without decimals When it totals it adds total #

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

renfrotim - 10 Feb 2008 18:23 GMT

Reply to this Message

Niek Otten - 10 Feb 2008 18:26 GMT

Please include a well described question in the body of your post

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

Reply to this Message

renfrotim - 10 Feb 2008 18:54 GMT

When using excel, I use rounded $#'s and need it to toal as such. Example:
$2.35 rounds to $2.
$2.35 rounds to $2.=$4 excel totals =$5 do to the .35+.35=.70 rounding up to
$5
I am using this in a propsal and 2+2=5 that's my problem

> Please include a well described question in the body of your post

Reply to this Message

Gord Dibben - 10 Feb 2008 19:10 GMT

In A1 enter =ROUND(2.35,0) returns 2

In A2 enter =ROUND(2.35,0) returns 2

In A3 enter =A1 + A2

You should see 4 in A3

What do you see and/or want to see?

Gord Dibben MS Excel MVP

>When using excel, I use rounded $#'s and need it to toal as such. Example:
>$2.35 rounds to $2.
[quoted text clipped - 3 lines]
>
>> Please include a well described question in the body of your post

Reply to this Message

David Biddulph - 10 Feb 2008 19:10 GMT

If you want to do calculations with rounded values, then you can produce
rounded values, so you could use =ROUND(A2,0)+ROUND(B2,0) instead of =A2+B2.

Another option is to format the cells to zero decimals, and then use Tools/
Options/ Calculation: Precision as displayed, but be aware that this can
cause confusion elsewhere.

Signature

David Biddulph

> When using excel, I use rounded $#'s and need it to toal as such. Example:
> $2.35 rounds to $2.
[quoted text clipped - 4 lines]
>
>> Please include a well described question in the body of your post

Reply to this Message