Minus Percentage..

  • Thread starter Thread starter shawn
  • Start date Start date
S

shawn

In Colum A I have prices.. In column B I'd like to show the price in column
A minus a 20% discount.. I can't figure it out..
 
In B2

=A2*.8

or enter .2 into cell B1, and use

=A2*(1-$B$1)

HTH,
Bernie
MS Excel MVP
 
Thanks! I think I might have tried something like that, but was putting in
the wrong number.. I get it now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a sales quote sheet - sum totals by license type 1
Excel Subtracting multiple columns from another column 3
% discount formulas? 3
Figuring out a lengthy formula. Probably quite simple... 3
Excel How to calculate percentage for time 1
Need formula to calculate List Price. 3
make Excel see a (one digit) number as text 5
No one has the same problem? 2

Back
Top