Thread: if statements
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default if statements

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)

--
Gary''s Student - gsnu200760


"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