| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiplying 2 columns with IF | Excel Discussion (Misc queries) | |||
| Multiplying Contiguous Values in an Array | Excel Worksheet Functions | |||
| Multiplying cell values | Excel Discussion (Misc queries) | |||
| Multiplying time values and numbers | Excel Discussion (Misc queries) | |||
| multiplying columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
