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

Similar Threads

Word VBA - Automatic change content of a cell in table using dropdown list 5
Table cross-check 0
Consolidation Table from Different Excel Tabs with Different Format 1
Mail Merge Directory Conditional Page Break 0
make Excel see a (one digit) number as text 5
Need formula to calculate List Price. 3
Student & Home? 1
Formula re value in column C or D, calculations made on either in column E? 8

Top