ExcelBanter - Multiplying values in columns

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Multiplying values in columns (https://www.excelbanter.com/new-users-excel/249684-multiplying-values-columns.html)

Ach

Multiplying values in columns

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.

Ms-Exl-Learner

Multiplying values in columns

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!

--------------------
(Ms-Exl-Learner)
--------------------

"Ach" wrote:

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.

Ms-Exl-Learner

Multiplying values in columns

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!

--------------------
(Ms-Exl-Learner)
--------------------

"Ach" wrote:

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.

All times are GMT +1. The time now is 04:32 AM.