Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement for fields with text
Hi,
I need help with a if statement. The look up column contains one of 3 text values - On time, Early, Late. I'm trying to use the OR function in the IF statement i.e. If (I2 = OR(on time, early, late)), Complete, In progress). However, the OR function only works with numerical values. Has anyone tried a similar 'if' statement (with text) successfully? Please tell me how you made it work. Also, let me know if there is any other statement that I can use to accomplish the above result. Thanks in advance for your advice. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement for fields with text
On Sun, 14 Oct 2007 19:06:00 -0700, Hemant
wrote: Hi, I need help with a if statement. The look up column contains one of 3 text values - On time, Early, Late. I'm trying to use the OR function in the IF statement i.e. If (I2 = OR(on time, early, late)), Complete, In progress). However, the OR function only works with numerical values. Has anyone tried a similar 'if' statement (with text) successfully? Please tell me how you made it work. Also, let me know if there is any other statement that I can use to accomplish the above result. Thanks in advance for your advice. It is NOT true that "OR function only works with numerical values". The OR function is a logical function evaluates Booleans. A proper syntax for what you seem to want to do is: =IF(OR(I2="on time",I2="early",I2="late"),execute_if_any_true,ex ecute_if_all_false) or, a bit shorter: =IF(OR(I2={"on time","early","late"}),execute_if_any_true,execute _if_all_false) --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement for fields with text
If(I2<"", "Complete", "In Progress")
"Hemant" wrote: Hi, I need help with a if statement. The look up column contains one of 3 text values - On time, Early, Late. I'm trying to use the OR function in the IF statement i.e. If (I2 = OR(on time, early, late)), Complete, In progress). However, the OR function only works with numerical values. Has anyone tried a similar 'if' statement (with text) successfully? Please tell me how you made it work. Also, let me know if there is any other statement that I can use to accomplish the above result. Thanks in advance for your advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
If Statement based on blank fields | Excel Worksheet Functions | |||
Duplicate fields does not match up! If statement | Excel Worksheet Functions | |||
Duplicate fields does not match up! If statement | Excel Worksheet Functions | |||
Duplicate fields does not match up! If statement | Excel Worksheet Functions |