How to change a value for the price column

MikeMCSD
MikeMCSD used Ask the Experts™
on
I need to change the whole Price column
to reduce that Price by 10%.
How can I do this?
thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010
Commented:
Hello,

one way:

- enter 0.9 into a cell
- copy that cell
- select your values
- use paste special and select "Multiply"
- Hit OK

cheers, teylyn
Most Valuable Expert 2011
Awarded 2010

Commented:
Alternatively, calculate the reduced price in a helper column. If your data is in column A:

=A1*0.9

Copy down. Select the results, copy and use Paste Special - Values to paste over the original data. Then delete the helper column.

cheers, teylyn
ramromconsultant
Commented:
I have been away from excel for a whle - but here's what I'd do:

In an unused column put a formula (in essence) = .9 * pricecolumn.

Use fill down to propagate formula to all rows.

Select the column; copy; select the price column; paste special - values.
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Reducing the price by 10% means multiplying it by 0.9

Enter 0.9 in any empty cell
select the cell and press ctrl-c (copy)
select all your column cells contaning the rate
right-click on the selection
select paste-special
Check the multiply option
OK

Author

Commented:
thanks all

Author

Commented:
I need to decrease the price by 13% instead of 10% now.

but I enter : 0.13 in an empty cell, it doesn't give the right price.

What do I need to use here?  thanks
Most Valuable Expert 2011
Awarded 2010

Commented:
100 - 10 = 90
100 - 13 = 87
So you need to use 0.87 instead of 0.9

cheers, teylyn

Author

Commented:
thanks
I missed this one in math class . . .

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial