| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Roundup Paste Special
I'd like to reduce the values of a range of cells by say 25%, and then
roundup the resultant values. paste special multiply (by 75%) gives me various values including decimals, but now I need to round these up, and I'm doing this manually, cell by cell, at the moment! It's driving me nuts....any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roundup Paste Special
I would use a second worksheet filled with formulae like this
=ROUND(Sheet1!A1,0) filled to the right and down as necessary. Regards, Stefi Al ezt Γ*rta: I'd like to reduce the values of a range of cells by say 25%, and then roundup the resultant values. paste special multiply (by 75%) gives me various values including decimals, but now I need to round these up, and I'm doing this manually, cell by cell, at the moment! It's driving me nuts....any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Roundup Paste Special
I have many spreadsheets in my workbook already, and I do not need to do this
in all cells...I am hoping there is a way without needing to do this! Sort of like a "paste-special-roundup" "Stefi" wrote: I would use a second worksheet filled with formulae like this =ROUND(Sheet1!A1,0) filled to the right and down as necessary. Regards, Stefi Al ezt Γ*rta: I'd like to reduce the values of a range of cells by say 25%, and then roundup the resultant values. paste special multiply (by 75%) gives me various values including decimals, but now I need to round these up, and I'm doing this manually, cell by cell, at the moment! It's driving me nuts....any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
| ROUNDUP copy/paste and fill handle not working | Excel Worksheet Functions | |||
Linear Mode
