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,
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,