R
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I am using $ #'s without decimals When it totals it adds total #
N
Niek Otten
Please include a well described question in the body of your post
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|
R
renfrotim
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
:
$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
:
G
Gord Dibben
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
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
D
David Biddulph
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.
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.