Calculate value based on range

Beth Wolfe

Hello Community!

*Caveat: I know enough about formulas to be dangerous but by no means understand nesting and such*

I would COL A (Points) to return a value based on a price range available in COL B (Price). For example:

$0.01 to $2.00= 1pt

$2.01 to $4.00= 2pts

$4.01 to $6.00 = 3pts

And so on

This is as far as I got: =IF(Price@row <= 2, 1, IF(Price@row <= 2.01, 2), IF(Price@row >=4.01, 3)))

which, for our experts, will quickly see is wrong.

Thank you!

Find more posts tagged with

Accepted answers

L_123

=IF(Price@row <= 2, 1, IF(Price@row <= 4, 2, IF(Price@row >=4.01, 3)))

You were pretty close. give that a try and see if it works how you want it to.

All comments

L_123

=IF(Price@row <= 2, 1, IF(Price@row <= 4, 2, IF(Price@row >=4.01, 3)))

You were pretty close. give that a try and see if it works how you want it to.

Paul Newcome

P.S.

It was only an extra closing parenthesis after your second IF...

Beth Wolfe

Thank you! I was able to use that and apply the logic to continue the range. Much appreciated!

L_123

@Paul Newcome while that was the only syntax error, the second if statement had a logic error in that it would have only caught values between 2.0 and 2.1

Paul Newcome

@L@123 I did miss that. Good catch there.

@Beth Wolfe What he said... Haha

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.