if statements

[jrt]

Please help..
I'm trying to create a formula in a field that will add a 1 for a true
response and a 0 for a false but i can't figure out how to combine multiple
if statements...here's what I'm trying to do...

If the datefield is null and valueX=1 or valueX=2 or valueX=3 then it is
true (1) else false (0)

I can't seem to figure out how to add in the multiple or statements.

thank you

 

[Gary''s Student]

Not sure what the datafield is but if A1 contains a number and you want
1,2,or 3 to yield True then:

=IF(OR(A1=1,A1=2,A1=3),1,0)

 

[BoniM]

If I understand correctly...

=IF(AND(A2="", OR(B2=1, B2=2, B2=3)), 1, 0)

if A2 is your date field and B2 is your "X" field, this will enter one in
the field if there is no date in A2 and B2 contains 1, 2, or 3. It will
enter 0 in the field if either contains anything else.
Hope it helps...

 

[RagDyer]

If datefield is A1, and X is A2, try this:

=(A1="")*OR(A2={1,2,3})