Comparing Years

[Ecjughead]

OK, here's a good one. I've been trying all kinds of formuals, nested IF statements and I'm just plain stumped!

Trying to compare birth/death date to census years. So imagine...

B1 = 1890 (birth)
B2 = 1975 (death)
A3 = 1850, A4 = 1860... (census years)

B3 cell would be formula to compare if A3 falls in between B1 and B2. Result would be either yes or no. Not sure what the best solution would be? IF with AND (which I've tried) or something completely different.

Suggestions?

 

[barry houdini]

Try this formula in B3 copied down

=IF(AND(B$1<=A3,B$2>=A3),"Yes","No")

 

[Ecjughead]

I believe you got it! Thanks so much!