ExcelBanter - What does ! do in an Excel formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - What does ! do in an Excel formula (https://www.excelbanter.com/excel-worksheet-functions/84991-what-does-do-excel-formula.html)

credulity

What does ! do in an Excel formula

In the formula :
INDIRECT('Work-Space'!$G$3,B12)

what is the function of the exclamation point?

Ken Johnson

What does ! do in an Excel formula

Hi credulity,

It's just the correct syntax.

I guess it's just the way Excel likes to be told that the previous text
is a sheet name.

Ken Johnson

All times are GMT +1. The time now is 05:33 PM.