In Excel 2000, is it possible to reference a constant (name) within a function using the value of anther cell? For example, how can I make the following work:
=A1*B1
where A1 is an integer and B1 is the name of a constant? Is there a character I can use to prefiex B1 such that Excel knows to look this up in its list of constants/names?
Thanks!
=A1*B1
where A1 is an integer and B1 is the name of a constant? Is there a character I can use to prefiex B1 such that Excel knows to look this up in its list of constants/names?
Thanks!