How do I calculate "x+x=2x" using Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
I mean, how would I calculate x+x without having to assign a number to x?
If I put:

A
1 x
2 x
3 =a1+a2 ( I get the error #VALUE!) ...I want it to show "2x". How do
i do that?
 
Hi Mel

what do you want to see if A2 has a "y" in it?

here's one option that might meet your needs ...
=IF(A1=A2,"2"&A1,A1&"+"&A2)

Cheers
JulieD
 
mel said:
I mean, how would I calculate x+x without having to assign a number t
x?
If I put:

A
1 x
2 x
3 =a1+a2 ( I get the error #VALUE!) ...I want it to show "2x"
How do
i do that?
Click to expand...

This will do what you want

=COUNTIF(A1:A2,\"X\")&\"X\

but it is not elegant
 
Thx Julie!

If it is:

A
1 x
2 y
3 x+y

I'm trying to to elementary row operations using excel.
 
Hi mel

the formula i put in my last post does this as well ... did it work for you?

Cheers
JulieD
 
I'm trying to do algebraic operations on the cells
so if I enter (all in a single cell):

2x+2y+y -----I would get---- 2x + 3y ----------in the same cell when I
press enter
x+y+z -----I would get ----- x+y+z -----------in the same cell when I
press enter
10+x+4x+y+y -----I would get----- 10+5x+2y---in the same cell when I press
enter

And then when I want to add two cells:
cell 1: 2x+2y+y
cell 2: x+y+z
cell 3: cell1+cell2 ---- I would get ------ 3x+4y+z ---in cell3 when I press
enter

I hope that explains what i'm trying to do, sorry I was vague before.
 
Excel was not designed for these sorts of operations. IMO, you should look for
different software.
 
Back
Top