Thanks:  0
Likes:  0

# Thread: Harsh request!

1. 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. 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. 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

#### Posting Permissions

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