If then statements in Expressions

[paulgalli5397]

Anyone know how to do this?  I'm hoping to come up with a radial bearing expression that I can add to a label style.  In order to label bearings, I need the expression to different things for different situations.  I don't see IF THEN in the list of commands in the expression creator box.  Any ideas?

Thanks!

Paul

[fcernst]

Just IF (test,true_val,false_val)... You need to use nested IF statements.

It would be nice to have a Select Case Statement

[paulgalli5397]

Thanks, that is working.  What about IF/AND expressions?  In this case, I'm trying to determine Quadrants, so I need to be able to determine if Both the northing and easting are positive, negative, or mixed. 

[troma]

That's where nesting comes in.

IF (Northing>0, (IF(Easting>0, [result for both +ive], [result for Northing+ive, Easting-ive])), (IF(Easting>0, [result for Northing-ive, Easting+ive], [result for Northing -ive, Easting ive])))