MS EXCEL: Spreadsheet pricing from Euro to GBP

  • Posted
  • Proposals 16
  • Remote
  • #13026
  • Archived
Paul A.Anita B.Stefan P.Heather N.Claire A. + 11 others have already sent a proposal.
  • 4

Description

Experience Level: Intermediate
Hi potential bidders!

We have 6 excel spreadsheets with product and pricing info on which we need to send to our customers. Problem is, the pricing is in Euros and we need to change the equation to Sterling so when our customers type in the quantity they require, it automatically calculates the total cost. The current formula does this already, but in Euros and we need it to be in GBP.

It's not a lot of work as I don't even think there are more than 100 different products in total and many of the prices are the same for each variation of product, but I can post you the pricelists on CD (the spreadsheets are big because of the pictures) or perhpas zip them and email the files over.

Please only bid if you definitely know how do this 100% accurately because pricing errors could cost us a small fortune.

We would also require info/equations on how we can do this ourselves in future.

Thanks in advance.

Clarification Board

    There are no clarification messages.