Help with a simple formula

[Princessboko]

I have a simple formula, L8=g8+i8. Sometimes i8 is text.

Is there anyway I can get the formula to work when there are numbers in these cells the result will be the result would be a number. But when i8 is text the result would be the number from g8 + the text of i8?

I get #VALUE! when there is text now.

Thanks...

 

[Andrew Poulsom]

Use:

=SUM(G8,I8)

Sum ignores text.

 

[Aladin Akyurek]

=SUM(G8:I8)

 

[Princessboko]

Thanks, that helps but how do I get the number from G8 to display with the text from I8?

 

[JamesKM]

Try =IF(ISERROR(G1+I1),G1&I1,SUM(G1,I1)) in L8.

(If G1 + I1 does not work the formula will concatenate the 2 cells, otherwise it will sum them.)

Hope this is what you are after

 

[RalphA]

I used:

IF(AND(CODE(H8)>47,CODE(H8)<58),G8+H8,G8&H8)

Works for me!

 

[IML]

one more for a slow friday

=CHOOSE(1+ISNUMBER(I8),G8&I8,G8+I8)

 

[RalphA]

And yet one more for this slow Friday:

=IF(ISNUMBER(I8),H8+I8,H8&I8)