Forum Discussion
Personal monthly budget that comes with excel 2016
I was looking at the personal monthly budget that comes with excel 2016 and it has cell program where it uses the programming:
| 1500 | 1400 | =[Projected Cost]-[Actual Cost] |
| 60 | 100 | =[Projected Cost]-[Actual Cost] |
| 50 | 60 | =[Projected Cost]-[Actual Cost] |
| 200 | 180 | =[Projected Cost]-[Actual Cost] |
as opposed to the normal f15-g15 for example. I'm curious how it uses words like [Projected Cost]-[Actual Cost] instead as well as to learn how to do it myself.
Thanks
- Smitty Smith
Microsoft
Hi Rick,
I don't know this template, perhaps the formula looks like
=[@[Projected Cost]]-[@[Actual Cost]]
If so that's the Excel Table with structured references
