# Free shipping calculation

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

Квалификация: Обработка данных, Excel, Архитектура ПО, Visual Basic

О работодателе:
( 169 отзыв(-а, -ов) ) Villanova Mondovì, Italy

ID проекта: #17797919

## 13 фрилансеров(-а) в среднем готовы выполнить эту работу за €23

sysdesigner13

Hi, bro. I have read your description CAREFULLY so I am very confidence for your project I am very experienced and skillful with calculation in Excel. You can visit my profile to confirm that. A few days ago, I Больше

€23 EUR за 1 день
(62 отзывов(-а))
5.7
aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

€24 EUR за 1 день
(68 отзывов(-а))
5.3
Proolancer

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 Больше

€14 EUR за 3 дней(-я)
(8 отзывов(-а))
4.3
sevillajk01

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 день
(20 отзывов(-а))
4.3
nikopolidis

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 dashb Больше

€30 EUR за 1 день
(2 отзывов(-а))
2.7
benith1

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
box1508

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
zra12

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
Mortasim

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
manasaatir

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
€24 EUR за 1 день
(0 отзывов(-а))
0.0
RAJSINGHBANGAR

i will do this job very well.............................................................................................................................................................................................. Больше

€19 EUR за 3 дней(-я)
(0 отзывов(-а))
0.0
€21 EUR за 3 дней(-я)
(0 отзывов(-а))
0.0