LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Its always the simple ones....Basic Circular Reference Problem.

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Circular reference toolbar not working [email protected] Excel Discussion (Misc queries) 3 May 29th 06 01:55 AM
Circular Reference nastech Excel Discussion (Misc queries) 1 April 27th 06 12:54 AM
Getting rid of a circular reference error message sharkfoot Excel Discussion (Misc queries) 9 March 26th 06 07:48 PM
goal seek circular reference etxrmm Excel Discussion (Misc queries) 0 March 16th 06 09:56 AM
Create dictionary of terms, create first time user site Solitaire Jane Austin New Users to Excel 1 January 19th 06 09:47 PM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"