[Excel] Need help with what shoul be an easy formula
I used to zip these out almost without thought, but it has been a while. If someone can help I'd appreciate it. I have 2 lists of photo file names and I'm trying to determine whether or not the name needs removed, or the file needs to be printed. (I'm missing Pascal about now.)
The data:
Col A = name from folder A, or blank Col B = name from folder B, or blank Col C = "True" or "False" (a calculated value dependent on other things) Col D = Action to take and the calculation I'm having trouble with:
If C = True, then D = "Done" If C = False, and then A is blank, D = "Print" If C = False, and then B is blank, D = "Remove"
I'm trying to perform a COUNTIF with a nested EXACT, but I'm putting something wrong somewhere.