Custom Excel sheet - Gross profit and gross Margin

Completed Posted Nov 22, 2015 Paid on delivery
Completed Paid on delivery

I need one customom excel sheet.

1. I will put my sale price into column 1.

2. Column 2 I will put in my commission, which is 40%.

3. Column 3 I need you to program the cell to fill with 100% of the profit.

4. Column 4 I need you to program the cell to fill with the gross profit for the sale.

5. Column 5 I need you to program the cell to fill with the gross margin for the sale (Divide column 3 by column 1)

Example

Sale Comminsion 100% Profit Gross Profit % Gross Margin %

$125.00 $10 $25 25% 20%

I need to be able to load up to 2000 lines.

Need quick. Any questions?

Excel

Project ID: #8950431

About the project

6 proposals Remote project Active Nov 22, 2015

Awarded to:

gokulanand

Hello I can get it done in the next 1 to 2 hours using Excel VBA. Do let me know if you are interested. Thanks

$30 USD in 0 days
(96 Reviews)
6.0

6 freelancers are bidding on average $25 for this job

jaylancer43

A proposal has not yet been provided

$30 USD in 0 days
(689 Reviews)
8.4
lashabuxo

please,believe mee I can do itplease,believe mee I can do itplease,believe mee I can do itplease,believe mee I can do itplease,believe mee I can do itplease,believe mee I can do itplease,believe mee I can do itplease,b More

$20 USD in 1 day
(18 Reviews)
4.7
nathanyel

Hi... I can get your job done within 2hours, I'll make placeholder cells so you can increase beyond 2000 entries if you want. Thanks

$25 USD in 1 day
(2 Reviews)
2.3
pransy123

A proposal has not yet been provided

$20 USD in 1 day
(1 Review)
1.7
taiaburbdon

I have also experience in ms office. thanks taiabur rahman skype: taiaburbd

$25 USD in 1 day
(0 Reviews)
0.0