1
   

help with excell

 
 
Reply Fri 2 Sep, 2005 07:55 am
I wonder if anyone out there can help me with an Excel problem i am having....

i want Excel to calculate a commission based on the following information the these columns:

gross sales
less expenses
net profit
% of profit

commission

the first part is easy and i can handle that...its the calculation of the commission that is giving me problems. The calculation of commissions is as follows:

if the percentage of profit is 20% then that is the commission amount eg: 20% of the net profit

if the percentage of profit is less than 20% then the commission amount is whatever that figure is: eg 19.8% times the net profit

if the percentage of profit is more than 20% then the commission amount is 20% of the net profit. eg: percentage of profit is 21.3% then the commission is 20% of the net profit...

if there is a loss (net profit greater than the sales) then the commission should reflect a negative percentage and therefore be deducted from any commissions due

i think that covers all the possibilities

Thanks in advance for any help you can give with this

Bert Hayford
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 1 • Views: 493 • Replies: 0
No top replies

 
 

Related Topics

Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » help with excell
Copyright © 2025 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.05 seconds on 05/02/2025 at 11:08:48