I have an original spreadsheet with pricing. Now I need to save this with a
10% discount and 15% discount etc....
I have an original spreadsheet with pricing. Now I need to save this with a
10% discount and 15% discount etc....
=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 [email protected]> wrote in message
news:[email protected]...
> I have an original spreadsheet with pricing. Now I need to save this with
a
> 10% discount and 15% discount etc....
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....
> 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" <[email protected]> wrote in message
news:[email protected]...
> =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 [email protected]> wrote in
> message
> news:[email protected]...
>> I have an original spreadsheet with pricing. Now I need to save this
>> with
> a
>> 10% discount and 15% discount etc....
>
>
Good point
--
Regards,
Peo Sjoblom
(No private emails please)
>
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "George Nicholson" <[email protected]> wrote in message
> news:%[email protected]...
>>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>>> =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 [email protected]> wrote in
>>> message
>>> news:[email protected]...
>>>> 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)
Bookmarks