# 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

( 153 reviews ) Villanova Mondovì, Italy

Project ID: #17797919

## Awarded to:

WeiSongJi

Hi I have read your project description and exciting. I think your project is very simple for me. I can finish your project immediately, and I can do perfectly. If you go with me in this project I can help you anyt More

€24 EUR in 1 day
(0 Reviews)
0.9

## 14 freelancers are bidding on average €23 for this job

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 More

€23 EUR in 1 day
(54 Reviews)
5.5
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 in 1 day
(52 Reviews)
5.1
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 in 1 day
(11 Reviews)
3.6
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 More

€14 EUR in 3 days
(3 Reviews)
3.0
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 More

€30 EUR in 1 day
(2 Reviews)
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 in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0
€24 EUR in 1 day
(0 Reviews)
0.0
RAJSINGHBANGAR

i will do this job very well.............................................................................................................................................................................................. More

€19 EUR in 3 days
(0 Reviews)
0.0
€21 EUR in 3 days
(0 Reviews)
0.0