Formula result as text or number

  • Thread starter Thread starter Werx
  • Start date Start date
W

Werx

Is there a way to set a formula that diferenciates text or numbers

A1 = 0.50
A2 = A1*1.2 ..(0.60)this part is easy
but when A1 has text
A2 = ######### ..because of the multiplication

I need A2 to ignore the multiplication when A1 = text


Is this posible?
 
Back
Top