HOW TO ADD 7% TO LIST OF PRICES

S

SHIGGA

I AM TRYING TO FIND OUT HOW TO ADD 7% TO A LIST OF PRICES, IS THERE AN EASY
FORMULA?
 
G

Gord Dibben

Place 1.07 in an unused cell.

Copy that then select the range to change.

Edit>Paste Special>Multiply>OK>Esc.

Delete the 1.07


Gord Dibben MS Excel MVP
 

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
Adding Window 7 1
I screwed up 0
Mail Merge Directory Conditional Page Break 0
How to make repeating drop-down lists? 2
Regarding Word Add in on Office 365 0
How to count the numbers in a Word document? 0
Visio 365 Change default connector arrow style 0

Top