ExcelBanter - how to copy same percentage to complete worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to copy same percentage to complete worksheet (https://www.excelbanter.com/excel-worksheet-functions/113367-how-copy-same-percentage-complete-worksheet.html)

steelbird

how to copy same percentage to complete worksheet

how do i copy a same percentage to complete worksheet for e.g if i need to
add 10% additional to my present figure

Dave Peterson

how to copy same percentage to complete worksheet

Put 1.1 (=110%) in an empty cell
edit|copy
select the range to adjust
edit|Paste special|check multiply
and clean up that cell with 1.1 in it.

steelbird wrote:

how do i copy a same percentage to complete worksheet for e.g if i need to
add 10% additional to my present figure

--

Dave Peterson

All times are GMT +1. The time now is 03:15 AM.