Help with formula
 

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

Help with formula
 

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

Help with formula
 

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

--
HTH

Kassie

Replace xxx with hotmail


"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

Help with formula
 

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

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

Help with formula
 

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


"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

Help with formula
 

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

Help with formula
 

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)

On Jun 5, 6:05*pm, 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

Help with formula
 

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",H 3=3),"EAB",IF(AND(G3="CTOD",H3=4),"ICTSPB",IF(AND( G3="ICTDD",H3=1),"FAS",IF(AND(G3="ICTDD",H3=2),"CS ET",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" wrote:

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

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

Help with formula
 

2003 = 7 levels, 2007 = 64 level

Lynda wrote:

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",H 3=3),"EAB",IF(AND(G3="CTOD",H3=4),"ICTSPB",IF(AND( G3="ICTDD",H3=1),"FAS",IF(AND(G3="ICTDD",H3=2),"CS ET",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" wrote:


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

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

Help with formula
 

Thank you Bob, I am using 2003.

"Bob I" wrote:

2003 = 7 levels, 2007 = 64 level

Lynda wrote:

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",H 3=3),"EAB",IF(AND(G3="CTOD",H3=4),"ICTSPB",IF(AND( G3="ICTDD",H3=1),"FAS",IF(AND(G3="ICTDD",H3=2),"CS ET",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" wrote:


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

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

Help with formula
 

You're welcome, have a great day!

Lynda wrote:

Thank you Bob, I am using 2003.

"Bob I" wrote:


2003 = 7 levels, 2007 = 64 level

Lynda wrote:


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(A ND(G3="ICTDD",H3=1),"FAS",IF(AND(G3="ICTDD",H3=2), "CSET",IF(AND(G3="ICTOD",H3=3),"ADB",IF(AND(G3="IC TDD",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" wrote:



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

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

Help with formula
 

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