Excel Help Pleaseeeeeeeee

[xxsindyxx]

OK here goes Im trying to pull data through form one excel worksheetsheet to another using the analysis below

=IF(AND(Data!D2>=Data!$B2,Data!D2<=Data!$C2),1,0)

However some cells in my data sheet are empty with no information in them so i would like to tell the formula to also leave blank cell if blank on data sheet. Hoping this makes sense to an excel expert!

<!-- / message -->
<HR style="COLOR: #ffffff" SIZE=1><TABLE border=0 cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD vAlign=center align=left></TD><TD height=40 vAlign=center align=right></TD></TR></TBODY></TABLE>

 

[Robert Mika]

Hi Sindy and welcome to the board.
You can try:
=IF(AND(Data!D2>="",Data!D2=""),"",IF(AND(Data!D2>=Data!$B2,Data!D2<=Data!$C2),1,0))

but this is just one of many possibilities.

 

[xxsindyxx]

Oh My Gosh, Im absolutely delighted, It worked!!! Ive spent so many weeks on trying to figure this out! Thank you so much this is very much appreciated.