| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does ! do in an Excel formula
In the formula :
INDIRECT('Work-Space'!$G$3,B12) what is the function of the exclamation point? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
