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...