Formula contains and ERROR???

[Legacy 259187]

Hello, I am trying to displace 3 different results, 0,1 or "", based on 4 arguments. The formula I am trying to do this with is =IF(AND(B$2>=Data!$L2,B$2<=Data!$W2),1,"",IF(AND (B$2>=Data!$M2,B$2<=Data!$P2),0,"")). Excel is telling me I an error. I must be missing something. This is for a gantt chart that I want to display results in a way that the chart tool cant help me with so I am having to try to build this from scratch. Looks like I have hit a wall. any help to point out the error here would be most appreciated.

 

[Legacy 259187]

Not sure why it did not copy the right amount of spaces. When I pasted it in the reply box the spaces were all present. when I posted, the spaces disappeared. Regardless, thanks for all your help. It worked out great and now I have a tool that makes my job easier and saves me a lot of time to concentrate on other task. My hats off to you, Sir,

 

[Andrew Poulsom]

Not sure why it did not copy the right amount of spaces. When I pasted it in the reply box the spaces were all present. when I posted, the spaces disappeared.

Oh I see. The vagaries of HTML.