3 Replies Latest reply on Mar 16, 2011 11:09 AM by philmodjunk

# calculation combining Left and Case statements

### Title

calculation combining Left and Case statements

### Post

Left (text; numberof characters) and a

Case(test; result)

I have a number in a field 6132 and I want to get the left value = 6

easy enough I use the LEFT function. But I want if the value is 6 the field to calculate "S"

Final answer results as "S" for 6132

Thanks

• ###### 1. Re: calculation combining Left and Case statements

Case ( Left ( YourField ; 1 ) = 6 ; "S" )

• ###### 2. Re: calculation combining Left and Case statements

If there anywhere that gives good examples or explains what functions can/how they wrap into other functions?

At list of what comes first?

• ###### 3. Re: calculation combining Left and Case statements

Not that I can think of, but it may help if you keep in mind that any place where you can use a calculation, is also a place where you can insert a call to another function to nest function calls inside of function calls.

I also find just sitting down with a simple test file and experimenting to be a good way to figure out ways to get a complex calculation to work.