Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Store Result in Cell with Value

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •