dslreports logo
 
    All Forums Hot Topics Gallery
spc
Search similar:


uniqs
385

artesian79
join:2001-10-16
West Chester, OH

artesian79

Member

[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.

Thank you.

workablob
join:2004-06-09
Houston, TX

workablob

Member

It seems that the last two IFs conflict.

If C is False D cannot be both Print and Remove.

Can it?

Blob

artesian79
join:2001-10-16
West Chester, OH

artesian79

Member

If the entry in C is false, then either A or B is blank. If it is A that is Blank, then D is "Print", but if it is B that is blank, D is "Remove".

workablob
join:2004-06-09
Houston, TX

workablob

Member

said by artesian79:

If the entry in C is false, then either A or B is blank. If it is A that is Blank, then D is "Print", but if it is B that is blank, D is "Remove".

So sorry, I did not read it correctly. I read and then as just then.

Blob
dmagerl
Premium Member
join:2007-08-06
Woodstock, IL

dmagerl to artesian79

Premium Member

to artesian79
=IF(C1=TRUE,"done",IF(A1="","Print",IF(B1="","remove","error")))

I think this does what is described