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.

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

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.