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? |
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) |