Hi all,

I am starting a new business and need some help setting up my pricing.

I'm a little new to excel, and have spent the day today looking through this forum and learning as I go. Forgive me please if I use the wrong terminology.

Here is what I have:
I have one workbook that lists all my COST prices, spread over a few worksheets. Then I have a second workbook that has all my RETAIL prices, also spreed over a few worksheets. (Both files are in the same folder).

Here is what I will do:
Each month I will do a review of our COST workbook, and amend the price changes as necessary. But what I would like is for these changes to reflect automatically in the RETAIL Workbook.

We will have a set MARGIN of 20% that needs to be added into the equation. This number may change up or down (depending on how business goes , and needs to be easily amended, so I think it need to be in a cell, and just referenced by the formula. That way I could change it, and the RETAIL Workbook could be updated automatically too.

Formula?

So here is the formula that I think that I need:
COST (Cell in workbook one) A1
ADD
MARGIN Percent (Cell in workbook two) B1
Equals
RETAIL (Cell in workbook two) C1


Could somebody help me to:
  • Write the formula
  • Show me where to enter it in the worksheets

Any help would be much appreciated.