How do I multiply columns?
I want to multiply a column by $2.5. I want to enter one formula so that
whatever numbers in column c is multiplied by $2.5. Numbers in column c vary, but I want them all multiplied by the same number |
simplest way is to enter 2.5 into an empty cell select that cell and copy it
select the column you want to change and paste special multiply "Horizon Dude" wrote: I want to multiply a column by $2.5. I want to enter one formula so that whatever numbers in column c is multiplied by $2.5. Numbers in column c vary, but I want them all multiplied by the same number |
All times are GMT +1. The time now is 09:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com