happyman5005
New Member
- Joined
- Jul 15, 2014
- Messages
- 3
This has been bugging the hell out of me for the past hour. It seems a simple concept but I haven't found anything helpful so far.
Say you have a multiplication table such as:
1 2 3 4 5 6 7 8 9...
on both the first row and column
For the first space (B2) I put in the formula =(B1*A2) and make sure I peg on or the other with $ such as =(B$1*A2) or =(B1*A$2)
Dragging this formula down vertically works out fine however if I autofill horizontally it gives me the previous sum of the previous column multiplied by the above sum. eg.
1 (1) 2 (2) 3 (6) 4 (24) 5 (120)
() being the column directly beneath
How would I make it so that it autofills correctly? Also for something as simple as filling in a multiplication table I feel like there would be a really easy way to do it however the online tutorials only give examples of starting from scratch where you make your own table rather than filling in an existing table.
Another example. Say I want to fill in a table calculating interests added onto a deposit every year such as the one below.
Row 1 ¥10,000 ¥20,000 ¥100,000
Row 2 1% 2% 3% 10% 1% 2% 3% 10% 1% 2% 3% 10%
row 3 (1year) ¥10,100
row 4 (2years)
row 5 (3years)
row 6 (4years)
row 7 (5years)
row 8 (10years)
I would have the formula =FV(B$8,A9,,-B$7) for the first column however I would only be able to use this formula for the first row. What would be the easiest way of filling in this table?
Say you have a multiplication table such as:
1 2 3 4 5 6 7 8 9...
on both the first row and column
For the first space (B2) I put in the formula =(B1*A2) and make sure I peg on or the other with $ such as =(B$1*A2) or =(B1*A$2)
Dragging this formula down vertically works out fine however if I autofill horizontally it gives me the previous sum of the previous column multiplied by the above sum. eg.
1 (1) 2 (2) 3 (6) 4 (24) 5 (120)
() being the column directly beneath
How would I make it so that it autofills correctly? Also for something as simple as filling in a multiplication table I feel like there would be a really easy way to do it however the online tutorials only give examples of starting from scratch where you make your own table rather than filling in an existing table.
Another example. Say I want to fill in a table calculating interests added onto a deposit every year such as the one below.
Row 1 ¥10,000 ¥20,000 ¥100,000
Row 2 1% 2% 3% 10% 1% 2% 3% 10% 1% 2% 3% 10%
row 3 (1year) ¥10,100
row 4 (2years)
row 5 (3years)
row 6 (4years)
row 7 (5years)
row 8 (10years)
I would have the formula =FV(B$8,A9,,-B$7) for the first column however I would only be able to use this formula for the first row. What would be the easiest way of filling in this table?