Macro to convert USD to EUR and some more calculation on prices

isasa74

New member
Joined
Aug 7, 2014
Messages
1
Reaction score
0
Points
0
ABCDEFG
VendorPLANTPART N.DescriptionNet PriceFreightDuty
100040NL108FC1.034PPDummy$ 501,53,7%



Hi Guys,

First of all thanks for a so helpful forum where users can make a full use of a so precious knowledge.

I' d need a Macro that can use an hyperlink for converting prices from USD to EUR plus some more calculations.

Starting from the above excel template in my dreams :nod: this Macro should


IF B:B = NL10

First convert the Net Prices in (E:E) from USD to EUR (capturing the up to date conversion rate from a web site) ; then add to converted Net Prices the 70% of freight in (F:F); then on the result calculating and adding the percentage of Duties (G:G) (3,7% in the sample).

So summing it up: convert via hyperlink Net prices in EUR; Net Price+70%freight= Price + Duties% (e.g. Price + 3,7% of price itself)

IF B:B = US20

No currency conversion required; Net prices (E:E) + 100% of freight

Thanks so much in advance for any help .
 
Back
Top