if multiple condition

Hi,

we have a sheet where want to do check some conditions
My All work in Sheet1 or we can use ActiveSheet function


1. in D8,
if D2>=B8 and D2<=C8 then "yes" else "no"
if D2<B8 then blank

2. In D9,
if D8 is not blank then D9 is blank
if D2<B9 then blank
if D8 is blank and if D2>=B9 and D2<=C9 then "yes" else "no"

3. In D10,
if D9 is not blank then D10 is blank
if D2<B10 then blank
if D9 is blank and if D2>=B10 and D2<=C10 then "yes" else "no"

Thank you very much Richard Buttrey


my prob solved

Thank you very much Richard Buttrey for making the code short