Is it possible to have a formula IF current sheet is named X?a

[excelos]

Is it possible to have a formula IF current sheet is named X?

 

[JackDanIce]

Yes. I've named a sheet "X" in one workbook and used an IF function in another workbook. I've also named a sheet "X" and used an IF statement on that sheet in the same workbook.

Have you tried? Is there further detail you can share?

 

[excelos]

Yes. I've named a sheet "X" in one workbook and used an IF function in another workbook. I've also named a sheet "X" and used an IF statement on that sheet in the same workbook.

Have you tried? Is there further detail you can share?

I have not tried.
How did you express 'if current sheet is named X' with formulas?

 

[JackDanIce]

Tried searching on Google, found this suggestion: http://tinyurl.com/y572kr6m

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Please do as follow to reference the active sheet tab name in a specific cell inExcel. 1. Select a blank cell, copy and paste the formula=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) into the FormulaBar, and the press the Enter key.11 Feb 2015

How to reference tab name in cell in Excel? - ExtendOffice


<cite class="iUh30" style="color: rgb(0, 102, 33); font-style: normal; font-size: 14px; padding-top: 1px; line-height: 1.43;">https://www.extendoffice.com/documents/excel/2618-excel-reference-tab-name.html</cite>