What does the ! notation mean in excel financial formulas?

  • Thread starter Thread starter lady ninja
  • Start date Start date
L

lady ninja

I am learning how to do NPV and breakeven analysis, and one of the
spreadsheet examples has "Breakeven!B7". What does that mean?
 
When you use sheetnames in a formula you need to add the exclamation point
so Breakeven!B7 refers to cell B7 in a sheet named Breakeven.
Excel will enter these automatically, if you type an equal sign and click on
another sheet tab and then on a cell A1 in that sheet and press enter you
will see

=Sheetname!A1

where Sheetname is the name of the sheet

--


Regards,


Peo Sjoblom
 
The information to the left of the '!' is the name of the worksheet.
The information to the right of the '!' is the cell reference or range.

Breakeven is the name of the worksheet/tab.
B7 is the address of the cell being referenced.

--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
 
Thanks Gary!!!!


Gary Brown said:
The information to the left of the '!' is the name of the worksheet.
The information to the right of the '!' is the cell reference or range.

Breakeven is the name of the worksheet/tab.
B7 is the address of the cell being referenced.

--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
Click to expand...
 
Back
Top