how do i take off 15% of bulk prices in excel

S

s14rsb

i have price list in excel but i need to take of 15% off all but if i had to
do it 1 by 1 it will take for everso is it possible to do it in one so
instead of taking hours it takes mins any help much welcome
 
C

Chip Pearson

In an empty cell, put the number 0.85 and copy that cell. Then
select the cells you wish to change. Go to the Edit menu, choose
Paste Special, and choose the Multiply operation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"[email protected]"
 
B

Bob Phillips

in a cell type .85
copy that cell

next select all the cells to be reduced
Edit>PasteSpecial, and check the Multiply button
OK

now clear the cell with .85 in, and all done

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top