View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Its always the simple ones....Basic Circular Reference Problem.

Hi Dave,

put .10 in one cell copy it and paste special for the range on the B column
adding, or, put 1.1 copy special mult. if you need 10% growth.

hth
regards from Brazil
Marcelo

"Dave Lomax" escreveu:

I have the simplest problem to solve and its giving me the biggest headaches.

I have a column of product prices (say: column B) and I wish to add 10% or a
fixed value of 0.1 to each cell in the column. I want to store the results in
the same cell that the initial number was sourced from and that the formula
runs in.

e.g. Cell B3 value 6.34
I put a formula in cell B3 : =b3+0.1
I want the final value of 6.44 to be stored in cell B3...

Is what I am trying to do possible or (as I suspect) will I need to involve
more cells/columns?

Many Thanks in advance for the advice,

Dave