Combining (if and) with an IFERROR

measterbrooks

I am trying to combine two statements. The original IFERROR statement works fine. I want to evaluate my duration column (milestones) and if duration is 0, then I want to simply evaluate baseline date - start date and put a specific value in the cell.

=IF(AND(Duration@row = 0, [Schedule Delta (Working Days)]@row = >1)), 0.2, (IFERROR([Schedule Delta (Working Days)]@row / Duration@row, ""))

Cory Page

I think you may have one too many ) in this spot.. " >1)), 0.2, " Try removing one of them and see if that helps.

Here is a sample from the help site:

=IF(AND([Units Sold]3> 50, [In Stock?]3 = 1), "In Stock", "Requires Restock")

measterbrooks

Thank you. I did have one too many. I also don't think it liked the = and > being separated by a space. I just got rid of the = in the formula and modified it to 0. It is working now. Many thanks.

Cory Page

No prob,