All of your IF tests, eg
=IF(B3=2, C3=2, ...

should look either like this:
=IF(AND(B3=2,C3=2), ..
if you meant AND

Alternatively, if you meant OR, then:
=IF(OR(B3=2,C3=2), ..

Try re-writing it based on your actual desired logic
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"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