Sleeper: Excel formula

[Anne Troy]

I want to choose a folder's tab location, depending on the content of the label put on the folder (mail merge).

So, if the first letter of the folder is A through I, it's 1, J through R is 2, and S through Z is 3.

What's the easiest way to write that formula? I know how it starts!!

=if(

ROFL!!

[Bob Phillips]

I want to choose a folder's tab location, depending on the content of the label put on the folder (mail merge).

So, if the first letter of the folder is A through I, it's 1, J through R is 2, and S through Z is 3.

What's the easiest way to write that formula? I know how it starts!!

=if(

ROFL!!

I have no idea where you got the IF from, but assuming you only want A-Z, and it is in A1

=(INT((CODE(A1)-65)/9)+1)*(A1>="A")*(A1<="Z")