JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,539
- Office Version
- 365
- Platform
- Windows
In the table below, I have assigned the name "Balance" to column F. I would like to replace "F6" in I6 with the named range, "Balance", but the offset function doesn't like it.
<tbody>
</tbody>
Is there a syntax that will make this work?
Thanks
R/C | C | D | E | F | G | H | I | J |
4 | Difference | Formulas | ||||||
5 | Date | Price | Shares | Balance | Literal | Relative | Literal | Relative |
6 | 1/31/19 | $45.49 | 100 | $4,549.00 | $161.00 | #REF! | G6: =F6-OFFSET(F6,1,0) | H6: =Balance-OFFSET(Balance,1,0) |
7 | 2/28/19 | $43.88 | 100 | $4,388.00 | ($819.00) | #REF! | G7: =F7-OFFSET(F7,1,0) | H7: =Balance-OFFSET(Balance,1,0) |
8 | 3/31/19 | $52.07 | 100 | $5,207.00 |
<tbody>
</tbody>
Is there a syntax that will make this work?
Thanks