Roundup with paste special

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I'd like to roundup the results to a paste special operation. I'm multiplying
100's of cells by, e.g. 0.7458, and this obviously results in an unrounded
number. I then have to manually amend all the cells to round the results.
I'm wondering is there is a means to "past special & roundup" simultaneously?
I use Excel 2003.
Al
 
If the cells are formatted as you wish to see them (eg as Number with
2 dp), you can use Tools | Options | Calculation tab and then check
Precision as Displayed - when you click OK XL will give you a warning,
as this could affect other values in your workbook. Once it has done,
you can go back and un-check that option, so that future use will not
be affected.

Hope this helps.

Pete
 
Have just re-read your title - the technique I described gives you
rounded numbers, not necessarily rounded UP.

Pete
 
Hi

If you can work with a VB solution, the following will carry out the task
for any range of cells that you select.

Sub RoundupValues()
Dim mult As Double, c As Range
mult = InputBox("enter Multiplier")
For Each c In Selection
c.Value = WorksheetFunction.RoundUp(c * mult, 0)
Next
End Sub


Copy the code above
Alt+F11 to invoke the VB Editor
Insert>Module
Paste Code into white pane that appears.
Alt+F11 to return to Excel

To use
Select the range of cells you want to Multiply
Alt+F8 to bring up the Macro dialogue
Select RoundupValues>Run
You will be prompted to input the Multiplier 0.7458 (or any other)
OK
 
Back
Top