Combining (if and) with an IFERROR

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, ""))

Find more posts tagged with

Accepted answers

All comments

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,

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.