LinkBack URL
About LinkBacks
How do you multiply cells containing numbers with letters.
Example: I have the following cells
A B C
2 4 6
I want to say "=A1*x + A2*y * A3*z" = 2x + 24yz
How is this done?
Note: This is just a simplified version of what I'm searching for.
How do you multiply cells containing numbers with letters.
Example: I have the following cells
A B C
2 4 6
I want to say "=A1*x + A2*y * A3*z" = 2x + 24yz
How is this done?
Note: This is just a simplified version of what I'm searching for.
Hi, welcome to the forum
I am a little confused by your question
For example...
When you say A1, do you mean the cell reference A1?
what would x be?
Assuming A1 is the cell-ref, and x is a variable value, you could put that value in a cell and then reference it...
A1*$B$1
or you could give B1 (containing hat variable) a range name (I would recommend more than just x)
What exactly are you trying to do here?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you
Yes A1 is a cell reference.
x is just a letter, not a variable value. I need an expression containing the letters x, y and z.
OK so what would x represent?
To have that in any meaningful way in a formula, x needs to be some value.
What are you trying to do?
a2=A1&"x +"&(B1*C1)&"YZ"
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You will have to assign the variables to actual values or cell references that will hold the values. Your algebraic formula will only be treated as text unless you make the changes.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks