# How can I insert a 10% discount on a spreadsheet

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

2. ## Re: 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 edit>paste special and check multiply

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

Regards,

Peo Sjoblom

"Bridget Nelson" <Bridget Nelson@discussions.microsoft.com> wrote in message
news:A28294AF-5159-47F9-8964-116CBAED2409@microsoft.com...
> I have an original spreadsheet with pricing. Now I need to save this with

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

3. ## RE: 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....

4. ## Re: How can I insert a 10% discount on a spreadsheet

> do edit>paste special and check multiply

May I suggest a slight modification:
Edit>PasteSpecial> select "Values" AND "Multiply", then >OK
Otherwise you will change any pre-existing formatting in the area being
(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

"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:uEAODp2\$FHA.1288@TK2MSFTNGP09.phx.gbl...
> =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 edit>paste special and check multiply
>
> do the same for 15% but use 0.85 instead
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Bridget Nelson" <Bridget Nelson@discussions.microsoft.com> wrote in
> message
> news:A28294AF-5159-47F9-8964-116CBAED2409@microsoft.com...
>> I have an original spreadsheet with pricing. Now I need to save this
>> with

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

>
>

5. ## Re: How can I insert a 10% discount on a spreadsheet

Good point

--
Regards,

Peo Sjoblom

>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
> "George Nicholson" <JunkGeorgeN@msn.com> wrote in message
> news:%23kWvJB3\$FHA.216@TK2MSFTNGP15.phx.gbl...
>>> do edit>paste special and check multiply

>>
>> May I suggest a slight modification:
>> Edit>PasteSpecial> select "Values" AND "Multiply", then >OK
>> Otherwise you will change any pre-existing formatting in the area being
>> (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" <terre08@mvps.org> wrote in message
>> news:uEAODp2\$FHA.1288@TK2MSFTNGP09.phx.gbl...
>>> =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 edit>paste special and check multiply
>>>
>>> do the same for 15% but use 0.85 instead
>>> --
>>>
>>> Regards,
>>>
>>> Peo Sjoblom
>>>
>>>
>>> "Bridget Nelson" <Bridget Nelson@discussions.microsoft.com> wrote in
>>> message
>>> news:A28294AF-5159-47F9-8964-116CBAED2409@microsoft.com...
>>>> I have an original spreadsheet with pricing. Now I need to save this
>>>> with
>>> a
>>>> 10% discount and 15% discount etc....
>>>
>>>

>>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1