I then used AutoFill to copy the relative formula to the remaining cells in column C. You could do the same with any of the IS functions listed above. As well as using Excel's logical functions ...