Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The real Horizontal Formula question
Hi again,
OK, here is another try, same thing. We know in adding numbers in a vertical fashion, the formula covers a range of cells (=SUM(A1:A30) -- that's a vertical stack of numbers. A horizontal example: I want to multiply whatever the number is in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). And I want it set up so that, like, in A1thru A30, the Col A number gets multiplied by 7 and that figure shows up next to it in column B. So it's multiplying across. B1 = A1 x 7. B2 = A2 x 7 etc. Is there a formula for that and where does it go? It seems to me I would have to enter the formula each time. Am I right or wrong? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
The real Horizontal Formula question
See my response in your other thread. Repeat the essence he
In B1 put the formula =A1 * 7 fill the formula down to row 30. Excel will automatically change the row number in the A# part of the formula, so down at row 30 it will have become =A30 * 7. Quick way to Fill the formula: after entering the formula in B1, select cells B1 through B30 and use Edit -- Fill -- Down "Melissa in Salem" wrote: Hi again, OK, here is another try, same thing. We know in adding numbers in a vertical fashion, the formula covers a range of cells (=SUM(A1:A30) -- that's a vertical stack of numbers. A horizontal example: I want to multiply whatever the number is in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). And I want it set up so that, like, in A1thru A30, the Col A number gets multiplied by 7 and that figure shows up next to it in column B. So it's multiplying across. B1 = A1 x 7. B2 = A2 x 7 etc. Is there a formula for that and where does it go? It seems to me I would have to enter the formula each time. Am I right or wrong? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
The real Horizontal Formula question
In B1 enter formula the below formula and drag/copy it down as required.
=A1*7 If you want to get the sum of all numbers in A1:A30 multiplied by 7 the formula is =SUMPRODUCT(A1:A30)*7 If this post helps click Yes --------------- Jacob Skaria "Melissa in Salem" wrote: Hi again, OK, here is another try, same thing. We know in adding numbers in a vertical fashion, the formula covers a range of cells (=SUM(A1:A30) -- that's a vertical stack of numbers. A horizontal example: I want to multiply whatever the number is in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). And I want it set up so that, like, in A1thru A30, the Col A number gets multiplied by 7 and that figure shows up next to it in column B. So it's multiplying across. B1 = A1 x 7. B2 = A2 x 7 etc. Is there a formula for that and where does it go? It seems to me I would have to enter the formula each time. Am I right or wrong? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
The real Horizontal Formula question
Oops..
=SUM(A1:A30)*7 If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: In B1 enter formula the below formula and drag/copy it down as required. =A1*7 If you want to get the sum of all numbers in A1:A30 multiplied by 7 the formula is =SUMPRODUCT(A1:A30)*7 If this post helps click Yes --------------- Jacob Skaria "Melissa in Salem" wrote: Hi again, OK, here is another try, same thing. We know in adding numbers in a vertical fashion, the formula covers a range of cells (=SUM(A1:A30) -- that's a vertical stack of numbers. A horizontal example: I want to multiply whatever the number is in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). And I want it set up so that, like, in A1thru A30, the Col A number gets multiplied by 7 and that figure shows up next to it in column B. So it's multiplying across. B1 = A1 x 7. B2 = A2 x 7 etc. Is there a formula for that and where does it go? It seems to me I would have to enter the formula each time. Am I right or wrong? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
The real Horizontal Formula question
On Jun 12, 11:43*pm, JLatham
wrote: See my response in your other thread. *Repeat the essence he In B1 put the formula =A1 * 7 fill the formula down to row 30. *Excel will automatically change the row number in the A# part of the formula, so down at row 30 it will have become =A30 * 7. Quick way to Fill the formula: *after entering the formula in B1, select cells B1 through B30 and use Edit -- Fill -- Down "Melissa in Salem" wrote: Hi again, OK, here is another try, same thing. *We know in adding numbers in a vertical fashion, the formula covers a range of cells (=SUM(A1:A30) -- that's a vertical stack of numbers. A horizontal example: *I want to multiply whatever the number is in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). *And I want it set up so that, like, in A1thru A30, the Col A number gets multiplied by 7 and that figure shows up next to it in column B. So it's multiplying across. B1 = *A1 x 7. B2 = A2 x 7 * etc. Is there a formula for that and where does it go? *It seems to me I would have to enter the formula each time. *Am I right or wrong? Excellent!! OK. You answered my ?. Excel will fill the correct A [number] as it goes down without me having to do it on every line. This is great. Thank heaven for this group. You guys are good. Melissa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
question on horizontal line on chart | Charts and Charting in Excel | |||
Horizontal axis with its real value | Charts and Charting in Excel | |||
Converting a Formula stored as String to real Formula | Excel Worksheet Functions | |||
Question for the real experts! | Excel Discussion (Misc queries) | |||
"real" formula | Excel Discussion (Misc queries) |