View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How can I insert a 10% discount on a spreadsheet

=A1*(1-10%)

where A1 holds the original value

if you want to do it without formulas, copy the values toa new sheet (right
click sheet tab and select move or copy, then check copy

now put 0.9 in an empty cell, copy it, select the newly cretaed values and
do editpaste special and check multiply

do the same for 15% but use 0.85 instead
--

Regards,

Peo Sjoblom


"Bridget Nelson" <Bridget wrote in message
...
I have an original spreadsheet with pricing. Now I need to save this with

a
10% discount and 15% discount etc....