I am working on a spreadsheet where I have 5 important columns. Column B is the "Completed" category. Columns C, D, E & F will all contain values (mainly "Y" or "N") when their associated tasks are completed.
What I would like is a formula for B that will search the C, D, E & F columns in that same row for any values, and if all 4 cells on that row have any non-blank value, change the text in that row of column B to "Y" - if all other cells of that row are blank, the text in column B for that row should instead display "N".
Thank you very much for your time and interest! I've been trying to piece this one together on my own, but am having no luck, and need to get back to doing the maintenance this spreadsheet is being used to track - what I'm really looking to do here is eliminate superfluous mouse-clicks, since I have enough of those to do as it is.
Change text in cell if other cells have any values