I have a decent sized function that is a combination IF/AND/OR function that simply determines a Y or N value based on numerous other cells in the same row. I would like to copy this formula down so that others can input info and not have to determine the Y or N value. However, when I do that, the value naturally becomes "N" for the rows that have not had any of the conditional info input. How can I copy the function down but not have a "N" value displayed in a row with no other info? Thank you in advance for any support.
-Andy
-Andy