Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am using $ #'s without decimals When it totals it adds total #
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am using $ #'s without decimals When it totals it adds total #
Please include a well described question in the body of your post
-- Kind regards, Niek Otten Microsoft MVP - Excel "renfrotim" wrote in message ... | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am using $ #'s without decimals When it totals it adds total
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 "Niek Otten" wrote: Please include a well described question in the body of your post -- Kind regards, Niek Otten Microsoft MVP - Excel "renfrotim" wrote in message ... | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am using $ #'s without decimals When it totals it adds total
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 On Sun, 10 Feb 2008 10:54:00 -0800, renfrotim wrote: 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 "Niek Otten" wrote: Please include a well described question in the body of your post -- Kind regards, Niek Otten Microsoft MVP - Excel "renfrotim" wrote in message ... | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am using $ #'s without decimals When it totals it adds total
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. -- David Biddulph "renfrotim" wrote in message ... 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 "Niek Otten" wrote: Please include a well described question in the body of your post -- Kind regards, Niek Otten Microsoft MVP - Excel "renfrotim" wrote in message ... | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM fx drops or adds 1 to total | Excel Worksheet Functions | |||
worksheet adds 1 or 2 values to totals | Excel Worksheet Functions | |||
Adds City but not Panmure ( Combined Total ) | Excel Worksheet Functions | |||
Total only those cells with Sum totals | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |