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
...
|