Multiplying values in columns

  • Thread starter Thread starter Ach
  • Start date Start date
A

Ach

I want to be able to create totals in one column from entries in another
column. For example if a3=10 a7=8 a11=8. I want the corresponding rows in
column b to be multiplied by 18.75. ie . b3= a3*18.75 b7=a7*18.75
b11=a11*18.75

Not every row has an entry.
 
Paste this formula in B3.

=IF(A3<>"",A3*18.75,"")

Now copy the A3 Formula and paste it for the remaining cells.

Remember to Click Yes, if this post helps!
 
Small correction in my previous post...

Paste this formula in B3.

=IF(A3<>"",A3*18.75,"")

Now copy the B3 Formula and paste it for the remaining cells.

Remember to Click Yes, if this post helps!
 

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

Columns 1
Alpha sorting (with a twist...?) 3
Sumproduct a column where 2 adj text columns contain same value 5
Insert a blank row between each used row in document 7
Excel Help to copy information from one row at a time to another sheet 1
Column formulas to subtract value from value 4
Remove specific cells in a column. 2
Excel VB Script Required to Insert PDF objects, Merge Cells and Format 0

Back
Top