Using letters within the variable table

Experimenter
Experimenter

I was wondering if it was possible to have letters incorportated into If/then statements or just variables in general. I'm trying to assign a part number that consists of letters and numbers to a nomial pipe size.

Sizes 2-8 work fine but when I get to the larger sizes they have letters assigned to them and solid edge reads them as zero per the formula for now until I can figure it out.

 

This is my formula as of right now:

 

IF( NomPipeDia <=2.5,1994,IF( NomPipeDia <=3.5,1995,IF( NomPipeDia <=4,1996,IF( NomPipeDia <=5,1997,IF( NomPipeDia <=6,1998,IF( NomPipeDia <=8,1999,IF( NomPipeDia <=10,1994A,IF(NomPipeDia <=12,1999B,0))))))))

 

 

1 REPLY

Re: Using letters within the variable table

Esteemed Contributor
Esteemed Contributor

You can't.  The Value column must be numeric.


Thanks,
Ken

Production: ST9 MP10
Testing: ST10 MP1