Copy/Paste values rounding problem.

's Computer Specifications

Hi,

I have a value in columnB say 3042.
In columnC, I am multiplying it with 20/100 say =3042*20/100 = 608.4
Result in columnD is 3042-608=2434.

When I copy & paste values in columnE, it yeilds 2433.6 but I want
2434.

Any ideas why?

's Computer Specifications

Try

=ROUNDUP(B1-C1,0)

Mike

"Sinner" wrote:

> Hi,
>
> I have a value in columnB say 3042.
> In columnC, I am multiplying it with 20/100 say =3042*20/100 = 608.4
> Result in columnD is 3042-608=2434.
>
> When I copy & paste values in columnE, it yeilds 2433.6 but I want
> 2434.
>
> Any ideas why?
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
paste values without copy-paste values	Rikkart	Microsoft Excel Programming	1	15th Mar 2010 03:01 PM
Find matching values, copy/paste values as well as values in ColA	ryguy7272	Microsoft Excel Programming	2	28th Sep 2009 06:20 AM
Copy/Paste how to avoid the copy of formula cells w/o calc values	=?Utf-8?B?RGVubmlz?=	Microsoft Excel Misc	10	2nd Mar 2006 10:47 PM
copy and paste values	ward kuipers	Microsoft Excel Charting	1	29th Jul 2004 05:45 PM
How do i compare values from two sheet and copy & paste if values match?	=?Utf-8?B?cm96Yg==?=	Microsoft Excel Programming	0	5th Mar 2004 12:06 AM