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 "if" 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="deb",'Settlement Sheet'!B9,0)

"Morris" wrote:

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 "if" 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)

Hi!

You have to create a defined name:

Goto InsertNameDefine

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

"Morris" wrote in message
...
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 "if" 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)

Morris Wrote:
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 "if" 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)
this should work
=IF('Settlement Sheet'!D9="deb",'Settlement Sheet'!B9,0)


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=536671