ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   DECREASE ALL NUMBERS IN A COLUMN BY A PERCENTAGE (https://www.excelbanter.com/excel-worksheet-functions/8480-decrease-all-numbers-column-percentage.html)

LoriK

DECREASE ALL NUMBERS IN A COLUMN BY A PERCENTAGE
 
I'm not knowledgable in excel. Can someone explain, in simple terms, how to
decrease all numbers in a column on a spreadsheet by a percentage? Thank you.

Frank Kabel

Hi
e.g. to decrease all by 5%:
- enter 0.95 in an empty cell and copy this cell
- select your values
- goto 'Edit - Paste Special' and choose 'Multiply'

--
Regards
Frank Kabel
Frankfurt, Germany

LoriK wrote:
I'm not knowledgable in excel. Can someone explain, in simple terms,
how to decrease all numbers in a column on a spreadsheet by a
percentage? Thank you.





All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com