so the next part of the question is, the formula outputs yes or no.

If the output is no, I want the words not eligible written in another column.
but that column cant have a formula in it, as when I run the mail merge script, it adds the date the email sent, and if there is already text in that row will skip it and go to the next one down.

So in my case
I have Column
N =email sent
O =Eligibility
P = Helper cell that will look at column O and if the answer is no, it will write not eligible in Column N