Search : in
By :

Percentage formula

Last answer on Jun 3, 2009 10:08:38 am BST thess, on Jun 3, 2009 8:57:11 am BST 
 Report this message to moderators

Hello,

Please help me for percentage formula, i want to have a price increse thru percentage, how can i do this in one formula only.As in i can just highlight all the existing price of all the items and there will be an answer in column of 10% as well as in 14% column.

Item Existing Price Increase Increase
10% 14%

q1 10
q2 20
q3 30
q4 40
q5 50
q6 60
q7 70
q8 80
q9 90
q10 100

Configuration: Windows XP Internet Explorer 6.0

Best answers for « percentage formula » in :
[Excel] – Countif Formula Show[Excel] – Countif Formula Issue Solution Note Issue I have one excel file in that Column "B" has the "pending or Closed" Status and Column "C" has "Severity 1, Severity 2 and Severity 3" I want to count in one cell with "Pending...
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Download All-In-One Calculator ShowAll-In-One Calculator is a scientific calculator with many features. It allows you to modify the data when calculating (add, delete or rectify values). It includes the following functions: a currency conversion, percentage calculation, formula...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...

1

 mubashir aziz, on Jun 3, 2009 10:08:38 am BST
  • +1

Let's say you have a list of values in A1:A10 and you need to increase these values all by 10%. Here is how;

1. Enter the number 1.10 into any blank cell and then Copy it
2. Now select the range A1:A100 and go to Edit>Paste Special
3. Choose Values from under Paste and then Multiply under Operation and click OK.

All value will now have increased by 10%

To decrease the values by 10% you would simply Enter =.901 in any blank cell and repeat the above steps ......

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

Reply to mubashir aziz