Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|