|
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? |
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? |
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? |
| All times are GMT +1. The time now is 06:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com