formula for sales commission please.
I need to calculate sales commissions based on amount and percentage. Can you help?
OS X Mountain Lion (10.8.2)
Robbie,
Assuming you have the Sales amount in column C and the commision is fixed... you calculate the commission (let's say in column D) as:
Commission = Sales * Commission%
D2=C2*0.05
this is shorthand for select cell D2, then type "=C2*0.05" then hit enter
I hope this helps