Can someone help me fix my formula; Goal output * Task Actual Duration is greater than Task Duration Days then "Longer" * Task Actual Duration is less than Task Duration Days then "Shorter" * Task Actual Duration = Task Duration Days then "Expected" * If Task Actual Duration is blank then " " Right now my formula doesn't account for the equal to component and doesn't account for if the "Task Actual Duration" is blank. =IF([Task Actual Duration]@row > [Task Duration Days]@row, "Longer", "Shorter") Thanks for helping me fix formula, my guess is it needs some nesting which i am not good at.

Greater than, Less than or equal to formula help, also produce "" when cell is blank

Can someone help me fix my formula;

Goal output

Task Actual Duration is greater than Task Duration Days then "Longer"
Task Actual Duration is less than Task Duration Days then "Shorter"
Task Actual Duration = Task Duration Days then "Expected"
If Task Actual Duration is blank then " "

Right now my formula doesn't account for the equal to component and doesn't account for if the "Task Actual Duration" is blank.

=IF([Task Actual Duration]@row > [Task Duration Days]@row, "Longer", "Shorter")

Thanks for helping me fix formula, my guess is it needs some nesting which i am not good at.

Find more posts tagged with

Accepted answers

Bassam Khalil

@dgloballab

Please try the following formula:

=IF(OR(ISBLANK([Task Duration Days]@row), ISBLANK([Task Actual Duration]@row)), "",
 IF([Task Actual Duration]@row > [Task Duration Days]@row, "Longer",
 IF([Task Actual Duration]@row = [Task Duration Days]@row, "Expected", "Shorter")))

the following screenshot shows the result:

All comments

Bassam Khalil

Hi @dgloballab

Hope you are fine, please try the following formula:

=IF(OR(ISBLANK([Task Duration Days]@row), ISBLANK([Task Actual Duration]@row)), "",
 IF([Task Actual Duration]@row >= [Task Duration Days]@row, "Longer", "Shorter"))

the following screenshot shows the result:

dgloballab

Thank you @Bassam Khalil Any chance you can add in if they match that it should provide "Expected"?

Bassam Khalil

@dgloballab

did you mean

[Task Actual Duration]@row = [Task Duration Days]@row then "Expected"

Bassam Khalil

@dgloballab

Please try the following formula:

=IF(OR(ISBLANK([Task Duration Days]@row), ISBLANK([Task Actual Duration]@row)), "",
 IF([Task Actual Duration]@row > [Task Duration Days]@row, "Longer",
 IF([Task Actual Duration]@row = [Task Duration Days]@row, "Expected", "Shorter")))

the following screenshot shows the result:

dgloballab

Thanks so much! works perfectly!

Bassam Khalil

@dgloballab

Excellent, i will be happy to help you any time.

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.