Home

Formula for - Reward increasing once certain level hit

%3CLINGO-SUB%20id%3D%22lingo-sub-421424%22%20slang%3D%22en-US%22%3EFormula%20for%20-%20Reward%20increasing%20once%20certain%20level%20hit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-421424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EAfter%20a%20bit%20of%20help%2C%20need%20to%20do%20a%20formula%20where%2C%20once%20the%20total%20hits%20a%20certain%20level%20the%20rate%20increases.%20So%20I%20pay%20a%20company%20%2450%20on%20the%20first%201000%20sales%2C%20then%20all%20sales%20after%20that%20are%20paid%20%24100.%20Need%20a%20running%20total%20of%20%24%E2%80%99s%20earned.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAny%20help%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-421424%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-422399%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20-%20Reward%20increasing%20once%20certain%20level%20hit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-422399%22%20slang%3D%22en-US%22%3EIf%20your%20cumulative%20sales%20start%20in%20A2%20and%20your%20payments%20start%20in%20B2%2C%20the%20formula%20in%20B2%2C%20copied%20down%20rows%2C%20is%3A%3CBR%20%2F%3E%3DLOOKUP(A2%2C%3CBR%20%2F%3E%7B0%2C1000%7D%2C%3CBR%20%2F%3E%7B0%2C50%7D%2B(A2%26gt%3B1000)*100)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433218%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20-%20Reward%20increasing%20once%20certain%20level%20hit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433218%22%20slang%3D%22en-US%22%3E%3CP%3EMany%20thanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433381%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20-%20Reward%20increasing%20once%20certain%20level%20hit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433381%22%20slang%3D%22en-US%22%3EWelcome.%3C%2FLINGO-BODY%3E
dazles
New Contributor

After a bit of help, need to do a formula where, once the total hits a certain level the rate increases. So I pay a company $50 on the first 1000 sales, then all sales after that are paid $100. Need a running total of $’s earned.

Any help appreciated

3 Replies
If your cumulative sales start in A2 and your payments start in B2, the formula in B2, copied down rows, is:
=LOOKUP(A2,
{0,1000},
{0,50}+(A2>1000)*100)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies