Results 1 to 9 of 9

Thread: MS Excel

  1. #1

    MS Excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need some help with MS Excel:

    Please help me with the formula in ms excel where if I type a value or a word in cell B2 the value in cell C3 should reflect in B3

    A B C D
    1
    2 How may I assist you?
    3 Please help with my injury
    4


    it was something like =IFB2<>0, C3... or something like that.........
    pls help me with this formula

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    I am not sure what you mean. Does the result in C3 change based on entry in B2? What do you mean should reflect B3? In your sample B3 is blank.


  3. #3
    I was able to get the answer...
    If I enter the following formula in cell B3 =IF(B2<>"",C3,"") the value which is in cell C3 appears in cell B3..
    Last edited by gary21812114; 2014-07-16 at 03:59 PM.

  4. #4
    I was able to get the answer...
    If I enter the following formula in cell B3 =IF(B2<>"",C3,"") the value which is in cell C3 appears in cell B3..

    Now I need further help on the same topic:..........

    Can we make the formula in such a way that value in B3 reflects with a delay of 15 seconds?
    Last edited by gary21812114; 2014-07-16 at 04:00 PM.

  5. #5
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Not with using VBA event macro.


  6. #6
    can you pls help me with that code?

  7. #7
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    I am not sure why you need this kind of action?

    Maybe I am not understanding. Please elaborate on exactly what you want.


  8. #8



    Please help me in getting this pop up "Hint: Animal with Trunk"

    This will act as guide/active assistance on various learning for beginners in different subject

  9. #9
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    VBA isn't my strong suit... I will leave to the experts...


Posting Permissions

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