Hi,
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
Thanks