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.
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 ......
