Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
what does stand

Forum home » Delegate support and help forum » Microsoft Excel Training and help » What does ! stand for?

What does ! stand for?

ResolvedVersion 2007

Caryn has attended:
Excel Intermediate course

What does ! stand for?

I know that $ is used for absolute referencing, can someone tell me what ! stands for?

I came across this formula:
=IF('Sheet 1'!K61>0,'Sheet 1'!K61,0)

and would like to know what the ! is used for so I can use this equation elsewhere....

RE: What does ! stand for?

Hi Caryn,

Thank you for your question.

In the formula you provided, the ! separates the Sheet name from the cell.

So the condition is stating:

If cell K61 on Sheet 1>0

I hope this answers your question.

Regards

Simon

RE: What does ! stand for?

Thanks for the very quick reply Simon! That does answer my question.

Excel tip:

Display Formulas Instead of Results in Excel 2010

By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again.

A much quicker and simpler way of displaying your formulas!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.