Nested Ifs Possible?

[nnaxor]

Hello. I am kind of new to business objects and I am trying to nest an if statement as a function, as I find no select or case argument. Is this possible? I use the following:

=If Min(<Locationname>) > &quot;G59346A&quot; AND Min(<Locationname>) < &quot;G59348F&quot; Then &quot;LIQUOR&quot; Else If Min(Left(<Locationname>,1) = &quot;G&quot; THEN &quot;GROCERY&quot; Else &quot;No&quot;

and I get a bad syntax and the then between &quot;G&quot; and &quot;GROCERY&quot; is highlighted.

Any ideas?

 

[ATP]

Looks like you are missing a bracket after the Left command.

Try :

=If Min(<Locationname>) > &quot;G59346A&quot; AND Min(<Locationname>) < &quot;G59348F&quot; Then &quot;LIQUOR&quot; Else If Min(Left(<Locationname>,1)) = &quot;G&quot; THEN &quot;GROCERY&quot; Else &quot;No&quot;