View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sally in Toronto Sally in Toronto is offline
external usenet poster
 
Posts: 5
Default If text then number

Simple problem I'm sure...

if(A1= "*",3,"")

A1 contains a formula that may or may not copy text from another worksheet.

I realize that the wildcard doesn't work in this context but anything else I
have tried comes back "true".

Thanks