Hello,
I have a tracker I'm using for a work project and have several parameters I need to fill in data for. For tracking, I'm using a simple if statement to show if there is data populated, return a "yes". If not, return "no". ex: =IF('PS(Opt,FI,Eq)'!B2="TBD","NO","YES"). I have a similar formula for B2-N2that references a different tab on my sheet. I want to show if all cells have a "Yes", return a "Yes" to show all items are completed. I'm trying to use this formula but get an error. Can someone see what I'm doing wrong?
=IF(AND(F5="YES",G5="Yes",H5="Yes",I="YES",J5="YES",K5="YES",L5="YES",M5="YES",N5="YES"),"YES","0")
Bookmarks