You are here:

Excel/reduce cell numbers by %

Advertisement


Question
hi Philip
sorry to bother you ( hope i explain this well) i have an excel sheet as a price list and i have about 40 cells with separate prices in each of them, is it possible for me to reduce or increase those prices by "percent" just by typing that percent in a separate empty cell thanks.
regards Rick

Answer
Yes you can.  Let's assume your price list is in cells B1 through B40.  In cell A1 you can put the percentage change you want.  In this instance the new price list will be in cells C1 through C40.

Put the increase or decrease in cell A1.
Put the curser in Cell C1 and type the following and hit return:

=(1+$A$1)*B1

This will put the price increase / decrease in cell C1.
Copy cell C1 and paste it to cells C2 through C40.  This will use the amount you typed into A1 for the entire price list.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Philip Buckley

Expertise

In Excel 2003 I can handle all basic questions such as how to copy and paste, all medium type questions such as pivot tables, and also am proficient in basic macros. I am also quickly learning 2007 where everything is pretty much the same but all in different places. Please be as detailed in writing your question as possible as that goes a long way in my ability to give the best answer possible.

Experience

I have 20 years of business experience, mostly in the area of finance and business consulting. Currently I am a Senior Business Consultant with a small business consulting firm. As part of my daily activities, I regularly use Excel to help make small businesses more efficient.

Education/Credentials
MBA from the Crummer Graduate School of Business at Rollins College.

©2016 About.com. All rights reserved.