Thank you Bob, I am using 2003.

"Bob I" wrote:

2003 = 7 levels, 2007 = 64 level

Lynda wrote:

Thank you all, your AND formula worked. As you can see now i have added more
to the formula
=IF(AND(G3="CTOD",H3=2),"HCTOD",IF(AND(G3="CTOD",H 3=3),"EAB",IF(AND(G3="CTOD",H3=4),"ICTSPB",IF(AND( G3="ICTDD",H3=1),"FAS",IF(AND(G3="ICTDD",H3=2),"CS ET",IF(AND(G3="ICTOD",H3=3),"ADB",IF(AND(G3="ICTDD ",H3=4),"ESD")))))))

I need to add another two sets onto this current formula probably becoming
quite cumbersome and hard to keep track of but it works so far. How far can i
go adding to this formula before it gets overloaded?

Thanks
Lynda

"Bob I" wrote:


Just guessing this is what you actually want.
=IF(OR(B3=2, C3=2),"CTOD",IF(OR(B3=2, C3=3),"ICTDD",IF(OR(B3=2,
C3=4),"ICTOD",IF(OR(B3=2, C3=5),"OCIO",""))))

Lynda wrote:


I was hoping someone might be able to help me with a better formula or a code
that will give me a result based on the formula below as it comes back saying
I have entered to many arguments.
=IF(B3=2, C3=2,"CTOD",IF(B3=2, C3=3,"ICTDD",IF(B3=2, C3=4,"ICTOD",IF(B3=2,
C3=5,"OCIO"))))
with the result appearing in cell D2.
Thanks in advance.
Cheers
Lynda