# Increase all numbers on excel October 21, 2010 at 07:50:21
Specs: Windows XP
 Is it possible to increase let's say by 5% all the numbers on one page?Thanks See More: Increase all numbers on excel

#1 October 21, 2010 at 08:23:33
 You might want to be more specific as to what you are actually trying to do.PasteSpecial allows you perform some basic mathematical operations on values in cells, but "increase by a specific percentage" isn't one if them. However, there may be a workaround.You could calculate 5% of each number on another sheet, perform a PasteSpecial...Values to eliminate the formulas on that sheet and then PasteSpecial...Add those values to the values on the original sheet.This should work for actual numbers on the original sheet, but might be problematic if the numbers are the result of a formula.Again, telling us what you really want to do might help us come up with a more specific solution.

Report •

#2
October 21, 2010 at 10:50:57
 ThanksTo be more specific, the page I use is: unit prices for spécific items and total.Example:unit price installation conextion total unit 100 35 35 170I hope it help

Report •

#3 October 21, 2010 at 11:18:00
 You've given us a hint of what your data looks like, but I'm still not sure what you are trying to do.If that's the "input" data, what should the "output" look like?

Report •

Related Solutions

#4
October 21, 2010 at 11:30:47
 OkAll numbers are increased by 5%Unit price from 100 to 105installation fron 35 to36.75conecxion from 35 to36.75total from 170to178.50

Report •

#5 October 21, 2010 at 11:51:28
 I'm going to assume that your data looks like this. A1:C1 contain actual values, D1 contains a formula:``` A B C D 1 100 35 35 =SUM(A1:C1) ```If that's the case, try this:``` A B C D E F G 1 100 35 35 =SUM(A1:C1) =A1*.05 =B1*.05 =C1*.05 ```That will give you 5% of each figure in A1:C1- Select E1:G1- Edit...Copy- Edit...PasteSpecial...Values- Select A1:C1- Edit...PasteSpecial...Add- Delete E1:G1The result should be:``` A B C D 1 105 36.75 36.75 =SUM(A1:C1) ```

Report •

#6
October 21, 2010 at 21:04:28
 It is exactly what I needed.Thank's so mutchNorm

Report • 