How I can multiply between text and number?

[sakijung]

Hi! I am newbie in excel. I have a question about how I can multipl
between text and number e.g.
+2*1 = 2
+1*a = error
Can I use the formula manage this? And I want to use the same formula
for the answer. Thank you in advanc

 

[Frank Kabel]

Hi
and what is your expected result for the second example data - an error
message?. If yes try
=IF(ISERROR(A1*A2),"error",A1*A2)

 

[JE McGimpsey]

What do you expect the answer to be when you use

=1*a

???

i.e, how does XL know what "a" is?

 

[sakijung]

I use sumproduct for this case. Next time I will show the whole answer.
Thank you very much.

 

[Peo Sjoblom]

We all wait with bated breath!

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom