using a name in an excel formula in a workbook

[Guest]

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)

 

[Guest]

Text should be in quotes.

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

 

[Biff]

Hi!

You have to create a defined name:

Goto Insert>Name>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

 

[davesexcel]

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 shee
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 shee
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