Nested If Formula

Could someone please help me with this IF formula? Much appreciated!

=IF([Total Individual Miles]1>350, "Five", IF(Total Individual Miles]1 <= 50, "One", IF(AND([Total Individual Miles]1 >50, [Total Individual Miles]1 <=150), "Two", IF(And([Total Individual Miles]1 >150, [Total Individual Miles]1 <=250, "Three", IF(And([Total Individual Miles]1 >250, [Total Individual Miles]1 <=350, "Four", "")))))

Find more posts tagged with

Formulas

Accepted answers

Nic Larsen

Try: =IF([Total Individual Miles]@row > 350, "Five", IF(AND([Total Individual Miles]@row > 250, [Total Individual Miles]@row <= 350), "Four", IF(AND([Total Individual Miles]@row > 150, [Total Individual Miles]@row <= 250), "Three", IF(AND([Total Individual Miles]@row > 50, [Total Individual Miles]@row <= 150), "Two", "One"))))

All comments

Nic Larsen

Vanessa Sandom

Yippee!! Thanks so much!! Made my day!

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.