Harsh request!
Harsh request!
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Harsh request!

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi! Thanks for your attention, Big Problem Here.

    Suppose in:
    Cell D1 =ROUND($I$2*47.5,2)
    Cell H1 =CONCATENATE("Deposit, Equivalent to USD47.5 @",$I$2,"")

    if the 47.5 in both formula has to change to 100, is there any way I can only edit in Cell D1 so that Cell H1 will automatically change 47.5 to 100????

    SO, that means what ever amount I type in D1, H1 should print what I type in D1..

    Thanks for those who help,

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Chaju

    Try this formula in H1

    =CONCATENATE("Deposit, Equivalent to USD"&D1/$I$2& "@",$I$2,"")

    Hope this is what you were after

    regards
    Derek

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

    Default

      
    Cell D1 =ROUND($I$2*47.5,2)
    Cell H1 =CONCATENATE("Deposit, Equivalent to USD47.5 @",$I$2,"")

    i'd use a cell reference instead of the number. that is, choose an out of the way cell (eg Z1) to type in your 47.5, or 100 or whatever and just refer to this cell in your formulae:

    =ROUND($I$2*$Z$1,2)
    ="Deposit, Equivalent to USD"&Z1&" @"&$I$2



    [ This Message was edited by: anno on 2002-04-01 21:26 ]

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
  •  

 

 
DMCA.com