Complex AND OR IF

Hey,
This should be my last question, I'm still learning.

I would like to compare 2 cells, Sheet1!B2 and Sheet1!B3
(
If sheet1!b2 is between the values of "D101" AND "D105", OR EQUAL TO "D201", OR EQUAL TO "D203", OR EQUAL TO "E110", OR EQUAL TO "E111", OR between the values of "H107" AND "H110" OR between the values of "H107" AND "H110" OR between the values of "H203" AND H205
)
AND
(
if sheet!b3 is EQUAL TO "E" )

then output a 1, if not, output a zero

The formula, which I deleted, excel reports back as being too long

Try:

=--AND(OR(Sheet1!B2={"D101","D102","D103","D104","D105","D201","D203","E110","E111","H107","H108","H109","H110","H203","H204","H205"}),Sheet1!B3="E")

check that I have inserted all appropriate codes.

The dashes coerce results of TRUE to 1 and result of FALSE to 0...

Then AND and OR functions return TRUE/FALSE boolean results... so don't need IF(), just coercement...