How I can multiply between text and number?

  • Thread starter Thread starter sakijung
  • Start date Start date
S

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
 
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)
 
What do you expect the answer to be when you use

=1*a

???

i.e, how does XL know what "a" is?
 
I use sumproduct for this case. Next time I will show the whole answer.
Thank you very much.
 
We all wait with bated breath!

--


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

Regards,

Peo Sjoblom
 
Back
Top