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

dgloballab

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.

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:

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.