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!
 
Back
Top