- #1
hedons
- 40
- 0
I need to plug some equations into Excel.
I am using the Insert-->Name-->Define feature to assign a given cell to a defined named variable.
Example... cell a1 = X, cell b1 =y
this way I can say cell c1 = X*Y rather than having to say c1=a1*b1
Here's the problem...
I need to define named variable for "X" and also for "x", but Excel doesn't seem to let me make both upper and lower case variables of the same letter. I can't believe that it's not possible. Help please!
Thanks!
I am using the Insert-->Name-->Define feature to assign a given cell to a defined named variable.
Example... cell a1 = X, cell b1 =y
this way I can say cell c1 = X*Y rather than having to say c1=a1*b1
Here's the problem...
I need to define named variable for "X" and also for "x", but Excel doesn't seem to let me make both upper and lower case variables of the same letter. I can't believe that it's not possible. Help please!
Thanks!