Store Result in Cell with Value

[afarooq]

Hi,

Can I multiply Cell B2 with D2 and Store the value in D2.

for e.g B2 has Value 3,
Cell D2 has value 69

I want to multiply B2 * D2 and store the result in D2.

Thank

 

[Mark W.]

You'll get a circular reference error unless you change to iterative calculation. It also would require the formula, =IF(B2,B2*D2,69), in D2. Inititally, B2 must be empty to initialize D2 at 69, then you enter 3 into B2. Each sucessive recalculation would multiply D2 by 3. Why do you want to do this?
This message was edited by Mark W. on 2002-03-11 14:58
This message was edited by Mark W. on 2002-03-11 15:07

 

[Jack in the UK]

Hi

Simply NO! in open formaul as Mark W states YOU WILL gwt a little blue dot and a pop up box ir Circula Ref this means you calculation using the same cell twice ie D2 value multi by A2 value thisis fine but wnating the answer in D2 is pushing it, it will hate it, look at it as a kind of loop if this were poss would excel just continue to change the result, like VBA loop can do just looks all nice and pretty but WORTHLESS.

Can be done in VBA thou:

The reason is we can assign a value to memory and recall it so D2 we can name as Jack so A2 we can name as IN THE so noew Jack add IN THE is fine, but we can clear the cells in VBA so they are empty and say add Jacj to IN THE and we are fine to put that back in the same cell, cool eh!

Then can also be done only once so as i explaind no looping takse place and and will get the correct result.

I cant say i recomend this but feel should it be a MUST MUST then can be done,

This is very close to the way programmes add 1 to a sales documents to always be differene say on close A1+1 will do this.

Hope that kinda of explains it in a fashion, maybe some one might translate a bit better my command of english is none so good at times.