I have attached a rough copy of the template I currently have set up. I have removed some columns and information, so the cells in the formula are slightly different than mentioned in previous replies.
The current formula is - =IF(AND(M3="0",P3="0",S3="0",V3="0",Y3="0",AB3="0" ,AE3="0"),"FC","NC")
I only need it to apply for the "Remaining" columns for the column numbers highlighted in blue (you'll see what I mean)
|