Help with formula

You're welcome, have a great day!

Lynda wrote:

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 ",H3=3),"EAB",IF(AND(G3="CTOD",H3=4),"ICTSPB",IF(A ND(G3="ICTDD",H3=1),"FAS",IF(AND(G3="ICTDD",H3=2), "CSET",IF(AND(G3="ICTOD",H3=3),"ADB",IF(AND(G3="IC TDD",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

It wouldn't make sense for it to be OR, as if B3=2 it gets picked up by the
first condition, so there is no point in including OR(B3=2, in the later
conditions.
--
David Biddulph

Kassie wrote:
You can go two directions here?
=IF(AND(B3=2,C3=2),"CTOD",IF(AND(B3=2,C3=3),"ICTDD ",IF(AND(B3=2,C3=4),"ICTOD",IF(AND(B3=2,C3=5),"OCI O"))))
or you could say
=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")) ))
depending on your requirements. In the first instance then, B3 must
=2, and C3 must = 2, to get CTOD
In the second one, If either B3=2 or C3=2, you will get CTOD


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