If what you mean is that the line you put into your subject line does
not work as a cell formula, then you're right. It's so truncated that
one can't tell what it is you're trying to do, but among other things
the parenthesis aren't right. You need a second paren after the IF and
some closing parens somewhere off to the right.
It's a lot easier if you use your message body to communicate your
problem, rather than trying to save money (?) by using just the subject
line...
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.