BusinessObjects Board

If Statements 'Begins With'


I have written the below

=If([Tote ID]<“2999999”; “0.03168”;If([Tote ID]=“B”; “0.005”))

However, The Tote ID need to read (Begins with) not = to as this is a 8 digit AN number and I have other cells beginning with F & J where I need to add a different then statement

How can I replace the = with a Begins with statement


Check out the Match() function.