Have you missed out some AND functions?
Did you intend to say
=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),"OCIO","I don't know the answer for this
condition")))) ?
--
David Biddulph

"Lynda" wrote in message
...
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