Find Jobs
Hire Freelancers

Free shipping calculation

€8-30 EUR

W trakcie realizacji
Opublikowano ponad 5 lat temu

€8-30 EUR

Płatne przy odbiorze
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
Identyfikator projektu: 17797919

Informację o projekcie

12 ofert
Zdalny projekt
Aktywny 6 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
12 freelancerzy składają oferty o średniej wysokości €23 EUR dla tej pracy
Awatar Użytkownika
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 w 3 dni
5,0 (15 opinii)
5,0
5,0
Awatar Użytkownika
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 w 1 dzień
5,0 (27 opinii)
4,5
4,5
Awatar Użytkownika
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 w 1 dzień
5,0 (2 opinii)
2,7
2,7
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
i will do this job very well...............................................................................................................................................................................................................................................................................................
€19 EUR w 3 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga ITALY
Villanova Mondovì, Italy
4,9
188
Zweryfikowana metoda płatności
Członek od cze 25, 2014

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.