ExcelBanter - Columns

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Columns (https://www.excelbanter.com/excel-discussion-misc-queries/249679-columns.html)

Ach

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

Jacob Skaria

Columns

In B1 apply this formula and copy down
=IF(A1="","",A1*18.75)

--
Jacob

"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

All times are GMT +1. The time now is 05:56 AM.