formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1430461%22%20slang%3D%22en-US%22%3Eformulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1430461%22%20slang%3D%22en-US%22%3E%3CP%3E%E2%80%A2%20Employee%20Total%20for%20each%20sales%20employee%3C%2FP%3E%3CP%3E%E2%80%A2%20The%20percentage%20(%25)%20of%20total%20sales%20for%20each%20employee%20by%20applying%20absolute%20cell%20reference%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%A2%20Total%20Sales%20of%20the%20quarter%3C%2FP%3E%3CP%3E%E2%80%A2%20The%20Commission%20Earned%20for%20each%20sales%20employee%20by%20applying%20absolute%20cell%20reference%3C%2FP%3E%3CP%3E%E2%80%A2%20Total%20Commission%20of%20this%20quarter%26nbsp%3B%3CBR%20%2F%3Eb.%20Enter%20the%20Excel%20function%20formula%20to%20calculate%20the%20following.%3CBR%20%2F%3E%3CBR%20%2F%3E%E2%80%A2%20Average%20Commission%20Earned%20%E2%80%A2%20Maximum%20Commission%20Earned%20%E2%80%A2%20Minimum%20Commission%20Earned%3CBR%20%2F%3Eassistance%20please%20with%20these%20formulas%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1430461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

• Employee Total for each sales employee

• The percentage (%) of total sales for each employee by applying absolute cell reference 

• Total Sales of the quarter

• The Commission Earned for each sales employee by applying absolute cell reference

• Total Commission of this quarter 
b. Enter the Excel function formula to calculate the following.

• Average Commission Earned • Maximum Commission Earned • Minimum Commission Earned
assistance please with these formulas 

0 Replies