Percentage increase

L

Lynne Mawson

I have a spreadsheet with 3 columns of figures. There is a price increase of
6% this year but I don't know how to use the existing spreadsheet and add the
6% to all 3 columns.
 
J

JE McGimpsey

One way:

Put 1.06 in an empty cell. Copy the cell. Select the values in the three
columns. Choose Edit/Paste Special, selecting the Values and Multiply
radio buttons. Click OK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Automatic change content of a cell in table using dropdown list 5
Dealing with a Pivot Table (when I don't want to) 0
Percentage Increase 11
Mail Merge Directory Conditional Page Break 0
Need Help with Macro Security 1
Need Help with a VBA subroutine 0
Extracting a cell value 2
VBA to see if a Section exists in Word Document, and if it does, delete it 2

Top