Roundup Paste Special

[Guest]

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?

 

[Guest]

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:

 

[Guest]

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"