# 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

Compétences : Traitement de Données, Excel, Architecture Logicielle, Visual Basic

Concernant l'employeur :
( 169 commentaires ) Villanova Mondovì, Italy

Nº du projet : #17797919

## 13 freelance font une offre moyenne de €23 pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(62 Commentaires)
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]

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(68 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(8 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(20 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
RAJSINGHBANGAR

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0