ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   multiple calcualtion (https://www.excelbanter.com/excel-programming/300431-multiple-calcualtion.html)

Nick

multiple calcualtion
 
Alrite,

I am not that experiened in Excel and was wondering if
anyone could help me with this prob I have:

I have a column of prices and I want to divide each number
within the column by 17.5%. Is there any way that I can do
this quickly instead of creating another column or
inputting every row manually???

Thanks

Nick

Rob

multiple calcualtion
 
Put 0.175 in a cell, then Copy the cell, select the column, and pastespecial divide.


All times are GMT +1. The time now is 09:05 AM.

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