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