How do I multiply columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column multiplied by a matrix 2
Excel 2003 1
The real Horizontal Formula question 4
constant multiplier 4
Conditional SUBTOTAL in XL210 Table 7
Help in writing a formula 1
Count total balance using two numbers 5
How to multiply column and rows 13

Back
Top