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
|