Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Excel Worksheet Functions | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) |