Calculate total of tiered payment

Hi all, is there a way to break a number down to make multiple calculations? For example, I am going to pay my sales team based on the number of units they sell. The first 50 units are paid at $20/unit, next 25 units are paid at $30/unit, etc.

In the photo below I want it to automatically calculate the total ($3,250) simply by taking the number of units (110 for Person A) and multiplying it according to the table below it.

Thanks for any help!

Find more posts tagged with

Accepted answers

Mark Cronk

Hi @Brad Mulder ,

Try this

=IF(Units@row<=50, units@row*20, IF(Units@row<=75, ((units@row-50)*30)+1000, IF(UNITS@ROW<=100, ((units@row-75)*30)+1750, ((units@row-100)*50)+3000)

Work?

Mark

All comments

Mark Cronk

Hi @Brad Mulder ,

Try this

=IF(Units@row<=50, units@row*20, IF(Units@row<=75, ((units@row-50)*30)+1000, IF(UNITS@ROW<=100, ((units@row-75)*30)+1750, ((units@row-100)*50)+3000)

Work?

Mark

Brad Mulder

Thanks Mark, that did work as hoped! Much appreciated!

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