MikeMCSD
asked on
How to change a value for the price column
I need to change the whole Price column
to reduce that Price by 10%.
How can I do this?
thanks
to reduce that Price by 10%.
How can I do this?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks all
ASKER
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
but I enter : 0.13 in an empty cell, it doesn't give the right price.
What do I need to use here? thanks
100 - 10 = 90
100 - 13 = 87
So you need to use 0.87 instead of 0.9
cheers, teylyn
100 - 13 = 87
So you need to use 0.87 instead of 0.9
cheers, teylyn
ASKER
thanks
I missed this one in math class . . .
I missed this one in math class . . .
=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