|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 1st, 2009, 12:51 AM
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
December 1st, 2009, 02:15 AM
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
December 1st, 2009, 02:16 AM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
