Salary Formula ( Calculation of Basic and commission)

Hi ,

I need formula for (Net Salary) col as follow :

To Count the sum in Col (Basic Salary)

Plus sum of 15% for amounts equal/less than 600 and sum of 25% for amounts more than 600) of the number in Col (Total Income)

We Pay our Employee (ex. sales man) salary with compensation of basic salary PLUS markup commission as follow:

Basic salary (Ex . fixed amount 100, 150 etc)
Plus, 15% for all incomes equal to 600 and less
Plus, 25% for all amounts more than 600

Examples as in attachment: The employee Amanda salary is (365) as her sales amount is 1300 which is counted as follow:

Basic (100) , Plus 15% for amount 600 (which is 90) and plus 25% for amounts above 600 (which is 175)

Can we have formula for this 🙄

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Ryan Sides

Hi @Waleed

Try this one...

=[Basic Salary]@row + (IF([Total Income]@row <= 600, [Total Income]@row * 0.15, 90 + (([Total Income]@row - 600) * 0.25)))

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.