ExcelBanter - How do I calculate a mark up margin in Excel - price= List

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I calculate a mark up margin in Excel - price= List - 40% (https://www.excelbanter.com/excel-discussion-misc-queries/231571-how-do-i-calculate-mark-up-margin-excel-price%3D-list-40%25.html)

Nanc

How do I calculate a mark up margin in Excel - price= List - 40%

I would like to build a formular to calculate pricing based on 40% off list.

Steven

How do I calculate a mark up margin in Excel - price= List - 40%

If price is in cell A1 enter the formula =A1*(1-0.4)
Hope this helps

Bob I

How do I calculate a mark up margin in Excel - price= List -40%

=A1*0.6

Nanc wrote:
I would like to build a formular to calculate pricing based on 40% off list.

All times are GMT +1. The time now is 12:35 AM.