You can't use names, or cell references in a calculated field.

nc wrote:
Hi

Can a defined 'Name' be used in a calculated field?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html