+ Reply to Thread
Results 1 to 5 of 5

How can I insert a 10% discount on a spreadsheet

  1. #1
    Bridget Nelson
    Guest

    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. #2
    Peo Sjoblom
    Guest

    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. #3
    bpeltzer
    Guest

    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. #4
    George Nicholson
    Guest

    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
    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" <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. #5
    Peo Sjoblom
    Guest

    Re: 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" <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
    >> 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" <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....
    >>>
    >>>

    >>


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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