Multiplying values in columns

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.
 
M

Ms-Exl-Learner

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!
 
M

Ms-Exl-Learner

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
Insert a blank row between each used row in document 7
Sumproduct a column where 2 adj text columns contain same value 5
Column formulas to subtract value from value 4
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Macro that analyses data from 3 columns and puts result in 4th 2
Generate a special numerical sequence in Excel 97 3

Top