Price List

[ladybird]

I have a price list that has the following headers for the columns:


Item- unit cost - regular price -dicsount count price - super discount price



For each item, I maintain 3 different prices depending on the types of customer. I have approximately 16 items in this list.

When my unit price changes, II would like a formula where I can manually change the unit cost, and then the three different prices for that item change automatically in the same amount that the unit cost changed.

Thanks

[shg]

Welcome to the forum, ladybird.

Please post a workbook that shows your data layout and where you want to enter the discount levels.