How can I insert a 10% discount on a spreadsheet
 

I have an original spreadsheet with pricing. Now I need to save this with a
10% discount and 15% discount etc....

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

How can I insert a 10% discount on a spreadsheet
 

More specifics would help... do you want to just replace every price shown
with a value that's 90% as much? Or is this a variable you need to set so
that you can adjust as needed?
I'll assume the latter (since it will get you the former)... Pick two
cells, one to be a label, one the value. For argument's sake, I'll assume
they're in A1 and B1. Enter the word Discount in A1 and 90% in B1.
Highlight both cells and Insert Name Define. Ensure that Excel is
creating the name Discount and that it references B1.
Now we need to apply the discount to your prices. I'll assume your existing
prices are in column B (with a product codes in column A), starting in row 4.
In c4, enter the equation =B4 * (1-Discount). The result should reflect the
discount applied to the old price. Autofill that formula by placing the
cursor over the lower right corner (it's called the fill handle); you'll see
the cursor change shape. Double-click and it should fill the column. Note
that if you change the discount in B2, all the prices in column C will change
in step.
Hope this is roughly what you were looking for. If not, please be as
specific as you can about what the output(s) should be.

"Bridget Nelson" wrote:

I have an original spreadsheet with pricing. Now I need to save this with a
10% discount and 15% discount etc....

How can I insert a 10% discount on a spreadsheet
 

do editpaste special and check multiply

May I suggest a slight modification:
EditPasteSpecial select "Values" AND "Multiply", then OK
Otherwise you will change any pre-existing formatting in the area being
pasted over with whatever format your "empty" cell had.
(Or adjust the format of the "empty" cell before copying it, and then you
don't need to worry about selecting "Values")

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Peo Sjoblom" wrote in message
...
=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....

How can I insert a 10% discount on a spreadsheet
 

Good point

--
Regards,

Peo Sjoblom

(No private emails please)




--
Regards,

Peo Sjoblom

(No private emails please)


"George Nicholson" wrote in message
...
do editpaste special and check multiply

May I suggest a slight modification:
EditPasteSpecial select "Values" AND "Multiply", then OK
Otherwise you will change any pre-existing formatting in the area being
pasted over with whatever format your "empty" cell had.
(Or adjust the format of the "empty" cell before copying it, and then you
don't need to worry about selecting "Values")

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Peo Sjoblom" wrote in message
...
=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....