Custom Excel sheet - Gross profit and gross Margin

已完成 已发布的 Nov 22, 2015 货到付款
已完成 货到付款

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

项目ID: #8950431

关于项目

6个方案 远程项目 活跃的Nov 22, 2015

授予:

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 在0天内
(96条评论)
6.0

有6名威客正在参与此工作的竞标,均价$25/小时

jaylancer43

A proposal has not yet been provided

$30 USD 在0天内
(689条评论)
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 更多

$20USD 在1天里
(18条评论)
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

$25USD 在1天里
(2条评论)
2.3
pransy123

A proposal has not yet been provided

$20USD 在1天里
(1条评论)
1.7
taiaburbdon

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

$25USD 在1天里
(0条评论)
0.0