Find Jobs
Hire Freelancers

Free shipping calculation

€8-30 EUR

进行中
已发布超过 5 年前

€8-30 EUR

货到付款
Hello i need to calculate, in excel, many conditions and keep the profit margin at least 20%. The varibable are . Shipping cost . Product cost . Free shipping rate The product more cheap cost 1€/kg The markup is 50% The fix costs are 3€ The shipping cost depend from weight The free shipping is when order total is > 39€ The module is already done (look [login to view URL]), the goal is make a macro that test From Total products > 1€ to <= 500€ And Weight > 0 to <=100Kg And print all conditions when the profit margin is = 20% (i need to know how much is requied for fix the loss for each condition, so i will set a different supplement to ask to customers for each condition). This is very simple for who know Vba, the file is done at 98% You will pass me the file with all conditions printed (in the range indicated above) and the macro also (because i have to make some tests after with little change in conditions) I already tested a macro, and i think you simple improve it Sub Macro1() ' ' Macro1 Macro ' Do Range("m2").GoalSeek Goal:=10, ChangingCell:=Range("b2") Range("m3").GoalSeek Goal:=10, ChangingCell:=Range("b3") Range("m4").GoalSeek Goal:=10, ChangingCell:=Range("b4") Loop Until Abs(Range("m2")) + Abs(Range("m3")) + Abs(Range("m4")) <= Range("m5") MsgBox "Work done", vbInformation End Sub
项目 ID: 17797919

关于此项目

12提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
12威客以平均价€23 EUR来参与此工作竞价
用户头像
Hello, I'm a web and desktop developer with 8 years of experience in this field, I read your project description and attached files I can dp what you want just get in touch with me and we can discuss more about your project. Best Regards Fouad
€14 EUR 在3天之内
5.0 (15条评论)
5.0
5.0
用户头像
hello! let me help you with your project. Just award the project to me and I will take care of the rest. Hope you will consider me. thanks
€19 EUR 在1天之内
5.0 (27条评论)
4.5
4.5
用户头像
My name is Nicola, an experienced accountant and financial controller, currently Group Controller in a multinational automotive group. I use Excel daily and I'm a wizard with this software! I have created many dashboard and macros for my company and as freelance. I've also worked as Senior Auditor in a Big4 for 5 years. I'm graduated in Business Administration and Financial Accounting. I create reports and financial dashboards on a daily basis to support management in taking business decisions. Reading your request, I'm quite sure to complete this task in few days. Of course, unlimited revisions till the output will meet your needs. Contact me if you're interested in my proposal and to provide me more details. Best regards Nicola
€30 EUR 在1天之内
5.0 (2条评论)
2.7
2.7
用户头像
i can do any of excel work as perfect if you want to do this please contact me soon with your information thank you very much
€23 EUR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
hi,i may be new here but i have a more than 10 years experience in Microsoft softwares like Excel,word ,and power point . I Can do this project LET'S START....PICK ME NOW
€27 EUR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Morning sir/madam, I am skillful in calculating, well versed in excel. If you give me the opportunity I will do my best and thanks.
€24 EUR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Dear Sir, thanks to you, i would to like to do your work. i have an experience on this filed last two your. thanks & best regds
€23 EUR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
hello I belong to the profession of chartered accountancy i think i can help you in the best possible way as i have related experience as well
€23 EUR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
i will do this job very well...............................................................................................................................................................................................................................................................................................
€19 EUR 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

ITALY的国旗
Villanova Mondovì, Italy
4.9
188
付款方式已验证
会员自6月 25, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。