Need help understanding formula bar notation

D

dylon25

New Member
Joined
Oct 25, 2022
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Hi, I'm relatively new to excel and starting with a new financial model and am trying to figure out what is going on. I've included a snapshot of my excel file,
I'm trying to understand what the ='K - Reserve'!AG12 is doing in the formula bar for cell C6 ( the other cells in the same column use a similar formula)
I see it is calculating the present value but I am not familiar with the formula notation, there is a reserve sheet with data that I am assuming it is referencing
Any help would just giving me an idea of what the formula is doing would be appreciated
 

Attachments

  • Capture!!!.PNG
    Capture!!!.PNG
    73.5 KB · Views: 10

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Hi & welcome to MrExcel.
That formula is simply pulling the information from cell AG12 on the K - Reserve sheet.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Revenue Allocation by Week
Replies
3
Views
226
ChetanPuri
C
A
  • Solved
Formulas and relative pointing
2
Replies
15
Views
404
atrainwreck
A
L
  • Question
I need help with a spreadsheet I have made for "ongoing project Timeline"
Replies
1
Views
264
sparky2205
sparky2205
M
  • Question
Formula to populate the next available cell in a column using data populated in another cell.
Replies
4
Views
304
Marshkevuk
M
M
  • Question
Creating a model - Unable to get trend function to run properly
Replies
2
Views
163
Misono
M

Forum statistics

Threads
1,214,517
Messages
6,119,984
Members
448,935
Latest member
ijat

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top