|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
June 5th, 2009, 02:05 PM
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
June 5th, 2009, 02:20 PM
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
June 5th, 2009, 02:23 PM
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
June 5th, 2009, 02:24 PM
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
June 5th, 2009, 02:46 PM
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
June 5th, 2009, 02:50 PM
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
June 5th, 2009, 03:03 PM
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  4,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
June 5th, 2009, 03:04 PM
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
June 5th, 2009, 03:26 PM
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
June 5th, 2009, 03:34 PM
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
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
