Help with formula

L

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
 
M

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

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
 
B

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

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
 
D

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

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&D1:D4,E1:E4)
 
L

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
 
B

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

:
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top