Algebra addition


J

Jonah

Row 1 1 3
4 y
Row 2 4 7
#VALUE!
Row 3 7 7
Row 4 14


How can I make these cells add together letters as well as integers?
e.g. 4 + y should equal 4 +y not #VALUE!

Jonah
 
Ad

Advertisements

J

Jonah

Jonah wrote badly:
Row 1 1
3 4 y
Row 2
4 7 #VALUE!
Row 3
11 11 + y
Row
4 22 + y
How can I make these cells add together letters as well as integers?
e.g. 4 + y should equal 4 +y not #VALUE! and 7 + ~VALUE! should
equal 11 + y etcetera, always adding the two cell in the row above.
Jonah
 
B

Bob Phillips

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Ad

Advertisements

B

Bob Phillips

Jonah,

Do you just want the text, such as

=A1 & "+" & B1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Algebra in Excel 3
Algebraic Functions 0
algebraic symbols 1
Algebraic Function 0
Algebra within a cell 3
Algebra graphic template 1
[newbie] solving algebra in excel 1
Please solve this algebra equation? 1

Top