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 :
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...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Reducing a Jpg image size ShowReducing a Jpg image size Step 1 (optional!): Skip GREYCstoration on the image Step 2: Reduce the resolution Step 3: Lower quality Step 4: Remove unnecessary information Conclusion If you find that your JPEG files are too large...
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...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
DNS (Domain Name System) ShowWhat is DNS? Each computer directly connected to the Internet has at least one specific IP address. However, users do not want to work with numerical addresses such as 194.153.205.26 but with a domain name or more specifically addresses (called...
Ask your question Reply

1

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

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
Ask your question Reply
They need your help