• 462K Members
• 5,983 Online
• 559K Conversations
SOLVED

## Formula help

Occasional Visitor

# Formula help

Hi Guys,

I'm really need help with a formula to help me with a commission banding structure, so I can just enter one amount of money and it does all the calculations behind it :)

Commission Structure:

0-£10,000 = 15%

£10,001 - £20,000 = 20%

£20,001 - £30,000 = 25%

£30,001 + = 30%

For example if someone made £33,000, they would get £10k at 15%, £10k at 20%, £10k at 25% and £3k at 30%.

If anyone can help me with this one I'd be forever grateful :)

Solution

# Re: Formula help

@06hstevens , if you add helper range as here

when the formula is like

`=SUMPRODUCT((E2-\$B\$2:\$B\$5)*((E2-\$B\$2:\$B\$5)>0)*\$C\$2:\$C\$5)`
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies