Minus Percentage..

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..
 
B

Bernie Deitrick

In B2

=A2*.8

or enter .2 into cell B1, and use

=A2*(1-$B$1)

HTH,
Bernie
MS Excel MVP
 
S

shawn

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

Top