Algebra addition

  • Thread starter Thread starter Jonah
  • Start date Start date
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
 
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.
Click to expand...

Jonah
 
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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)
 
Back
Top