IF AND with Less and greater than is not working

I am trying to use this formula.

IF(AND([Time Remaining]@row = "Closed", [Closed Date ageing]@row >= 90,[Closed Date ageing]@row <= 180), "90-180 Days", "More")

where [Closed Date ageing]=203 but still it is giving output "More"

Can you please tell me where I'm making mistakes?

Thank You

Suman

Find more posts tagged with

Formulas

Accepted answers

All comments

markkrebs

What result do you want for 203? your formula will correctly give 90-180 Days if the aging is 90 to 180 AND closed.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.