Cancel
Showing results for 
Search instead for 
Did you mean: 

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

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

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



Ken

Production: ST10 MP7
Testing: SE 2019
http://Grundey.blogspot.com