Thread: Using text in an IF statement?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
The Hun The Hun is offline
external usenet poster
  
Posts: 14
Default Using text in an IF statement?
Using Excel 2002

This is what I want to do...
A1 = a number or text
A2 = a number
A3 = A1*A2

If A1 is text, what is the correct IF statement in A3 so I don't get
#Value as the answer?

Thanks,
Reply With QuoteReply With Quote