software

Can I make a calculation of the selling price of an item to arrive at the
cost of the item while using another cell to input a desired mark-up
percentage, without creating a separate cell that contains gross margin?

For example, cell A1 contain the number 100, cell A2 is used to input a
desire mark-up percentage (20 percent). I would like cell A3 to equal 80.Try

=A1*(1-A2)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;sdmccabequot; gt; wrote in message
...
gt; Can I make a calculation of the selling price of an item to
gt; arrive at the
gt; cost of the item while using another cell to input a desired
gt; mark-up
gt; percentage, without creating a separate cell that contains
gt; gross margin?
gt;
gt; For example, cell A1 contain the number 100, cell A2 is used to
gt; input a
gt; desire mark-up percentage (20 percent). I would like cell A3
gt; to equal 80.
gt;
Perfect - thanks.

quot;Chip Pearsonquot; wrote:

gt; Try
gt;
gt; =A1*(1-A2)
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;sdmccabequot; gt; wrote in message
gt; ...
gt; gt; Can I make a calculation of the selling price of an item to
gt; gt; arrive at the
gt; gt; cost of the item while using another cell to input a desired
gt; gt; mark-up
gt; gt; percentage, without creating a separate cell that contains
gt; gt; gross margin?
gt; gt;
gt; gt; For example, cell A1 contain the number 100, cell A2 is used to
gt; gt; input a
gt; gt; desire mark-up percentage (20 percent). I would like cell A3
gt; gt; to equal 80.
gt; gt;
gt;
gt;
gt;