Thread: if statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jrt jrt is offline
external usenet poster
 
Posts: 7
Default if statements

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