What does ! stand for?

Resolved · Low Priority · Version 2007

Thu 26 Nov 2009, 09:56 Delegate Caryn said...

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....

Thu 26 Nov 2009, 11:22 Trainer Simon said...

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

Thu 26 Nov 2009, 11:28 Delegate Caryn said...

RE: What does ! stand for?

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

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips

What does ! stand for?

What does ! stand for?

RE: What does ! stand for?

RE: What does ! stand for?

Excel articles

Excel tip:

Viewing two Excel 2010 Workbooks at the same time