View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student
 
Posts: n/a
Default assign a number value to a text. ie, PL equals .5

Put the .5 in an un-used cell. Select the cell and then pull-down:

Insert Names Define and enter plate then click add and click ok.

You can then use the name in a formula:

=plate*12.345
--
Gary's Student


"JWDesigns" wrote:

I'm using different material "plate, angle, tube steel" I would like to
assign a number value to that text. ie. plate would equal .5 Is there a way I
can do this?