Creating a formula to determine cost based on different factors

Hello!

I am trying to find a formula. Basically, in column A I have a number (example-1500) and I am looking to find a formula that will calculate the cost based on range.

I.E. if the number in Column A is 0-1500...multiple by 5. If the number in Column A is 1501-2000, multiple by 10.

Can anyone guide me in the right direction?

Find more posts tagged with

Formulas

Accepted answers

All comments

ker9

Hi @alex_hacker

See if this will work for you:

=IF([Column Name]@row < 1501, [Column Name]@row * 5, IF([Column Name]@row < 2001, [Column Name]@row * 10))

Replace "Column Name" with the name of your column.

Hope this helps!

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.