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