IF Formula

Ana Hernandez

Hi everyone,

I'm having trouble with the IF formula:

what I want to to be able to classify a task depending on the amount of hours that we need to develop it.

so I have this chart:

1 - 500 hours = 1

500 - 1000 hours = 2

1000 - 1500 hours = 3

1500 - 2000 hours = 4

more than 2000 hours = 5

=IF([Total Hrs]@row < 500, 1, [Total Hrs]@row < 1000, 2, [Total Hrs]@row < 1500, 3, [Total Hrs]@row < 2000, 4, [Total Hrs]@row > 2000, 5)

Could someone please help me? thank you so much.

Find more posts tagged with

Accepted answers

Heather Duff

@Ana Hernandez ,

You're close! Try this:

=IF([Total Hrs]@row < 500, 1, IF([Total Hrs]@row < 1000, 2, IF([Total Hrs]@row < 1500, 3, IF([Total Hrs]@row < 2000, 4, IF([Total Hrs]@row > 2000, 5, "")))))

Let me know if it works!

Best,

Heather

All comments

Heather Duff

@Ana Hernandez ,

You're close! Try this:

=IF([Total Hrs]@row < 500, 1, IF([Total Hrs]@row < 1000, 2, IF([Total Hrs]@row < 1500, 3, IF([Total Hrs]@row < 2000, 4, IF([Total Hrs]@row > 2000, 5, "")))))

Let me know if it works!

Best,

Heather

Ana Hernandez

It worked!!! thank you so much :) you're the best!🤩

Heather Duff

@Ana Hernandez Happy to help!

Sign in to join the conversation!

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.