By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,490 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,490 IT Pros & Developers. It's quick & easy.

Mutiplying Within a Column

P: 2
I need to multiply within a column. Suppose there are 2 columns a & b with 12 rows. I want to multiply A1 with B1 till A4*B4. So I can get the results till C4 but my C5 is equal to C1 * B5, C6 is equal to C2 * B6 till C8.

Then again C9 is equal to C5*B9. Please tell me a formula for this and the pattern will change after every four steps.

Thanks
Nov 28 '11 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,709
As you cannot test the Row or Column, nor can you reference a Row with a number below 1, you will need a formula in C1 of :
Expand|Select|Wrap|Line Numbers
  1. =$A1*$B1
This can be copied to cells "C2:C4".

Cell "C5" will need to be :
Expand|Select|Wrap|Line Numbers
  1. =$C1*$B5
and can be copied all the way through to cell "C12"
Nov 28 '11 #2

P: 2
Hey i am really sorry for posting it under excel, I want to do the same in ACCESS .. It will be great if someone could help.
Nov 28 '11 #3

NeoPa
Expert Mod 15k+
P: 31,709
I changed it to Excel as that's the only way your question made the remotest sense.

Please explain what you really want. If it's an Access question then I need something that makes sense or I'll have to delete the thread.
Nov 28 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.