software

I have a workbook in excel 2002 that has several worksheets within. There is
the first sheet into which all the data is imputed. each other sheet refers
to a staff member whose function is actioned on the first sheet.
At the moment I am useing an quot;ifquot; formula eg
=IF('Settlement Sheet'!D9=1,'Settlement Sheet'!B9,0)
this takes the date on sheet 1 and places it into the appropriate sheet and
cell for the correct employee. (each employee has a different number)

What I want is to change using a number to using a name eg
=IF('Settlement Sheet'!D9=deb,'Settlement Sheet'!B9,0)Text should be in quotes.

=IF('Settlement Sheet'!D9=quot;debquot;,'Settlement Sheet'!B9,0)

quot;Morrisquot; wrote:

gt; I have a workbook in excel 2002 that has several worksheets within. There is
gt; the first sheet into which all the data is imputed. each other sheet refers
gt; to a staff member whose function is actioned on the first sheet.
gt; At the moment I am useing an quot;ifquot; formula eg
gt; =IF('Settlement Sheet'!D9=1,'Settlement Sheet'!B9,0)
gt; this takes the date on sheet 1 and places it into the appropriate sheet and
gt; cell for the correct employee. (each employee has a different number)
gt;
gt; What I want is to change using a number to using a name eg
gt; =IF('Settlement Sheet'!D9=deb,'Settlement Sheet'!B9,0)
gt;

Hi!

You have to create a defined name:

Goto Insertgt;Namegt;Define

Name: deb
Refers to: =1
OK

Then:

=IF('Settlement Sheet'!D9=deb,'Settlement Sheet'!B9,0)

will be the same as:

=IF('Settlement Sheet'!D9=1,'Settlement Sheet'!B9,0)

Biff

quot;Morrisquot; gt; wrote in message
...
gt;I have a workbook in excel 2002 that has several worksheets within. There
gt;is
gt; the first sheet into which all the data is imputed. each other sheet
gt; refers
gt; to a staff member whose function is actioned on the first sheet.
gt; At the moment I am useing an quot;ifquot; formula eg
gt; =IF('Settlement Sheet'!D9=1,'Settlement Sheet'!B9,0)
gt; this takes the date on sheet 1 and places it into the appropriate sheet
gt; and
gt; cell for the correct employee. (each employee has a different number)
gt;
gt; What I want is to change using a number to using a name eg
gt; =IF('Settlement Sheet'!D9=deb,'Settlement Sheet'!B9,0)
gt;

Morris Wrote:
gt; I have a workbook in excel 2002 that has several worksheets within.
gt; There is
gt; the first sheet into which all the data is imputed. each other sheet
gt; refers
gt; to a staff member whose function is actioned on the first sheet.
gt; At the moment I am useing an quot;ifquot; formula eg
gt; =IF('Settlement Sheet'!D9=1,'Settlement Sheet'!B9,0)
gt; this takes the date on sheet 1 and places it into the appropriate sheet
gt; and
gt; cell for the correct employee. (each employee has a different number)
gt;
gt; What I want is to change using a number to using a name eg
gt; =IF('Settlement Sheet'!D9=deb,'Settlement Sheet'!B9,0)
this should work
=IF('Settlement Sheet'!D9=quot;debquot;,'Settlement Sheet'!B9,0)--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=536671