Reversing a formula in my existing pricing spreadsheet

£20-250 GBP

已完成

已发布

将近 9 年前

£20-250 GBP

货到付款

I have a very useful pricing spreadsheet which uses some fairly complex formulas to calculate prices across 3 sales channels at a set profit margin, based on unit cost. I've attached the file. On tab1 cell E2, you enter the desired profit margin. On tab2 column B:B, the unit costs are entered. Then by dragging down the next 3 columns, you are given the different prices per sales channel. What I need (in addition to this) is to be able to calculate the profit margin by entering in selling prices and unit costs (rather than calculate the selling price by entering profit margin and unit cost). Can anyone think of a way to alter this spreadsheet to achieve this? Or would I need to start from scratch? Would greatly appreciate any help. Thanks.

Excel

项目 ID: 8219825

关于此项目

11提案

远程项目

活跃9 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel, include a complex formula :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara :)

£23 GBP 在3天之内

4.9

(86条评论)

5.3

11威客以平均价£55 GBP来参与此工作竞价

@sy3d

A proposal has not yet been provided

£100 GBP 在2天之内

4.9

(191条评论)

6.8

@dviruki

Dear Sir/Madam, I have 12 years of experience with Excel and VBA while working in finance, audit and accounting industries (including 4 years at a Big 4 audit firm). There is no need to start from scratch, it's not difficult to add profit margin calculation to the spreadsheet. I'm immediately available and will provide quick turnaround. Thank you!

£20 GBP 在1天之内

5.0

(39条评论)

4.8

@surekash7096

I have reviewed your pricing list and can modify as per your requirement with your inputs. Ready to start work immediately.

£55 GBP 在1天之内

5.0

(9条评论)

3.3

@TonmoyRoy111

A proposal has not yet been provided

£30 GBP 在2天之内

5.0

(20条评论)

3.4

@redouaneaberdin

Hi there My name is Redouane I am very interested in your project. I await your response. thank you in advance.

£20 GBP 在0天之内

5.0

(12条评论)

2.8

@MohsanEijaz

I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the factors in your project.

£150 GBP 在3天之内

0.0

(0条评论)

0.0

@jitinchadha1984

Dear Employer/s Greetings from Innovations India!! We are among the top 400 freelancers on this website out of the total population of more than 14 million. We have high job completion rate along with excellent customer reviews. We are the group of professionals serving global clients from more than seven years in the below fields:- *SEO *Academic Writing *Photoshop Designing *Content Writing *Resume / CV Writing *Remote Support *Article Writing *PowerPoint Presentations *MS Office Works *Product Description *Desktop Support *Data Entry *Newsletter *Outsourcing *Graphic Designing *Press Releases *Virtual Assistant *e-Marketing *Tag Line / Slogan *Accounting Jobs *Website Development We can deliver you the best services within the budget. Looking forward to an opportunity for serving you in achieving your targets. Best Regards Innovations India

£21 GBP 在1天之内

0.0

(0条评论)

0.0

@gopiande

A proposal has not yet been provided

£20 GBP 在2天之内

0.0

(0条评论)

0.0

@thushanw

I can do very well this job. because i have good experience & knowledge in Ms Excel & Excel formulas. Then i am sure i can easy to do this task

£33 GBP 在3天之内

0.0

(0条评论)

0.0

@munyuahmw

Dear Sir/Madam, I hope that you are well today. I posses the required skills as per your request to handle your work with utmost professionalism . I offer quality work and timely delivery; this makes me well suited to handle your work. The quality will make you keep coming for more. Kindly allow me to work on to your project. Regards, Munyuahmw

£133 GBP 在2天之内