Help with formula

[Lynda]

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

 

[Max]

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
---

 

[Kassie]

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),"OCIO"))))
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

--
HTH

Kassie

Replace xxx with hotmail

 

[Bob I]

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",""))))

 

[Jacob Skaria]

Dear Lynda

Try the below and feedback

=IF(B3=2,LOOKUP(C3,{0,2,3,4,5,6},{"","CTOD","ICTDD","ICTOD","OCIO",""}),"")


If this post helps click Yes

 

[David Biddulph]

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")))) ?

 

[muddan madhu]

Try this one.

Put this in col D and Col E
2 CTOD
3 ICTDD
4 ICTOD
5 OCIO

now in cell d2 put this formula
=LOOKUP(B3&C3,2&D14,E1:E4)

 

[Lynda]

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(AND(G3="ICTDD",H3=1),"FAS",IF(AND(G3="ICTDD",H3=2),"CSET",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]

2003 = 7 levels, 2007 = 64 level

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(AND(G3="ICTDD",H3=1),"FAS",IF(AND(G3="ICTDD",H3=2),"CSET",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

:

 

[Lynda]

Thank you Bob, I am using 2003.

2003 = 7 levels, 2007 = 64 level

 

[Bob I]

You're welcome, have a great day!

Thank you Bob, I am using 2003.

:

 

[David Biddulph]

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.