if statements
If datefield is A1, and X is A2, try this:
=(A1="")*OR(A2={1,2,3})
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jrt" wrote in message
...
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
|