IF/AND/OR Function to return blank cell

[apvost]

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

 

[Peter_SSs]

apvost

Is this what you mean?

If the data to be entered is in column A and your formula in column B, then in, say, B2 (copied down):
=IF(A2="","",your existing formula here)

 

[apvost]

Thanks Peter, worked like a charm!

-Andy