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

Back
Top