software

Is there a way to use the name of a worksheet in a formula?

I would like to use the 'if' function and have one of the criteria be
the name of the worksheet.

Thanks--
Deborah J Doyle
------------------------------------------------------------------------
Deborah J Doyle's Profile: www.excelforum.com/member.php...oamp;userid=33526
View this thread: www.excelforum.com/showthread...hreadid=533220The following formula will return the name of the worksheet on
which it appears.

=MID(CELL(quot;filenamequot;,A1),FIND(quot;]quot;,CELL(quot;filenamequot;,A1),1) 1,33)

Note that the file must have been saved to disk for the formula
to work. Also, leave the quot;filenamequot; text intact -- do not
substitute the actual file name--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

quot;Deborah J Doylequot;
lt;Deborah.J.Doyle.26c0pa_1145148602.2042@excelfor um-nospam.comgt;
wrote in message
newseborah.J.Doyle.26c0pa_1145148602.2042@excelf orum-nospam.com...
gt;
gt; Is there a way to use the name of a worksheet in a formula?
gt;
gt; I would like to use the 'if' function and have one of the
gt; criteria be
gt; the name of the worksheet.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Deborah J Doyle
gt; ------------------------------------------------------------------------
gt; Deborah J Doyle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33526
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=533220
gt;

THANKS!! the formula worked perfectly!--
Deborah J Doyle
------------------------------------------------------------------------
Deborah J Doyle's Profile: www.excelforum.com/member.php...oamp;userid=33526
View this thread: www.excelforum.com/showthread...hreadid=533220