Can I assign a number to a name and use the name in a sum?

[beeno]

I have a master schedule. I was wondering if I could assign a name to a
number, for example George is 3, Bob is two, so that when I put George and
Bob together in a schedule I could get it to add up to 5. Make sense??

[Trevor Shuttleworth]

Insert | Name | Define... | Names in workbook: George | Refers to: =3 | Add
Insert | Name | Define... | Names in workbook: Bob| Refers to: =2 | Add

In a cell you can then specify =George, = Bob, =George+Bob, etc., and get 3,
2, 5, etc.

Regards

Trevor


"beeno" <[email protected]> wrote in message
news:[email protected]...
>I have a master schedule. I was wondering if I could assign a name to a
> number, for example George is 3, Bob is two, so that when I put George
> and
> Bob together in a schedule I could get it to add up to 5. Make sense??