PDA

View Full Version : Excel formula



Anne Troy
05-26-2005, 12:42 PM
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!!:devil:

xld
05-26-2005, 01:10 PM
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!!:devil:

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")