View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default Updating cells by adding 5%

Try this

in a cell type 0.05 and copy it.

Select the cells u want to multiply | go to edit | paste special |
values | multiply | ok



On Sep 24, 11:07*am, Jill wrote:
I have several cells that have numeric values in them and I need to update
each cell by 5%. *How can I create a formula in the first cell and copy it to
all my other cells so that I do not have to mulitply each cell by 5%????
--
Jill