Minus Percentage..

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

 

[Bernie Deitrick]

In B2

=A2*.8

or enter .2 into cell B1, and use

=A2*(1-$B$1)

HTH,
Bernie
MS Excel MVP

 

[shawn]

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