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...

"jrt" wrote:

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