...

%3CLINGO-SUB%20id%3D%22lingo-sub-1168851%22%20slang%3D%22en-US%22%3ERe%3A%20What%20is%20the%20formula%20for%20commission%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1168851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F533069%22%20target%3D%22_blank%22%3E%40Christie1991%3C%2FA%3E%26nbsp%3BStart%20by%20describing%20how%20the%20commission%20would%20be%20calculated.%20In%20other%20works%2C%20what%20is%20the%20calculation%20you%20would%20do%20on%20a%20piece%20of%20paper%20or%20with%20a%20calculator%3F%20Then%2C%20I'm%20sure%20someone%20here%20can%20make%20a%20working%20formula%20for%20your%20template.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1170710%22%20slang%3D%22en-US%22%3ERe%3A%20What%20is%20the%20formula%20for%20commission%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1170710%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20commission%20rate%20now%2C%20its%207%25.%26nbsp%3B%3C%2FP%3E%3CP%3Eim%20trying%20to%20do%20an%20IF%20function%20(hoping%20that's%20the%20right%20function%20for%20this)%E2%80%A6%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20how%20to%20do%20all%20the%20function%2C%20what%20do%20I%20put%20in%20the%20false%20part%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20understand%20how%20to%20do%20what%20you%20said%2C%20this%20just%20doesn't%20compute%20in%20my%20head%20at%20all%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1170758%22%20slang%3D%22en-US%22%3ERe%3A%20What%20is%20the%20formula%20for%20commission%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1170758%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei'll%20just%20attach%20my%20spreadsheet%20because%20my%20brain%20is%20just%20banging%20symbols%20together%20now%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1171098%22%20slang%3D%22en-US%22%3ERe%3A%20What%20is%20the%20formula%20for%20commission%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1171098%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F533069%22%20target%3D%22_blank%22%3E%40Christie1991%3C%2FA%3E%26nbsp%3BYes%2C%20that's%20right!%20But....%20if%20you%20want%20to%20be%20able%20to%20copy%20the%20formula%20down%20the%20column%20you%20need%20to%20fix%20the%20reference%20to%20C2%20by%20adding%20dollar%20signs.%20I've%20added%20some%20formulae%20in%20your%20file%20(re-attach).%20See%20what%20happens%20when%20you%20leave%20out%20the%20dollar-signs%20and%20copy%20the%20formula%20in%20F5.%20Doing%20is%20the%20best%20way%20of%20learning!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178494%22%20slang%3D%22en-US%22%3ERe%3A%20What%20is%20the%20formula%20for%20commission%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You!!!%20You%20have%20been%20very%20helpful%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1168441%22%20slang%3D%22en-US%22%3E...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1168441%22%20slang%3D%22en-US%22%3E%3CP%3E...cant%20delete%20post%20so%20editing%20it%20instead%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1168441%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-1170787%22%20slang%3D%22en-US%22%3E...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1170787%22%20slang%3D%22en-US%22%3E%3CP%3E...%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

...cant delete post so editing it instead

3 Replies
Highlighted

@Christie1991 Start by describing how the commission would be calculated. In other works, what is the calculation you would do on a piece of paper or with a calculator? Then, I'm sure someone here can make a working formula for your template.

Highlighted

...

Highlighted

@Christie1991 Yes, that's right! But.... if you want to be able to copy the formula down the column you need to fix the reference to C2 by adding dollar signs. I've added some formulae in your file (re-attach). See what happens when you leave out the dollar-signs and copy the formula in F5. Doing is the best way of learning!