Commission Formula

[ntaylor1]

Hi, I own a Salon and wish to set up a commission spreadsheet for my employees. I know that there has to be a way to do this in Excel. I want to be able to set it up with one side being 75% and the other 25%. Meaning, my employees pocket 75% of the sale and I pocket 25%. I would like to be able to put the total dollar amount and two columns of 75/25, starting at $1.00-$200.00

PLEASE HELP!!!!!!!!!!!!!

 

[VoG]

Something like this? Formulas in B2 and C2 filled down

Excel Workbook
	A	B	C
1	$	75%	25%
2	1	0.75	0.25
3	2	1.50	0.50
4	3	2.25	0.75
5	4	3.00	1.00
6	5	3.75	1.25
7	6	4.50	1.50
8	7	5.25	1.75
9	8	6.00	2.00
10	9	6.75	2.25
Sheet2

 

[ntaylor1]

EXACTLY like that! Thank you soooo much!