| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste values rounding problem.
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy/Paste values rounding problem.
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste up to values in last row | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| Copy/Paste Values | Excel Programming | |||
| How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
Linear Mode
