=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. .">
Most valuable professional
  • Hot Topics

Excel Formula contains and ERROR???

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.

This question generated 32 answers. To proceed to the answers, click here.

This thread is current as of October 2, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel