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