Nested IFs

[Alvaro]

Please, I need a for me complex formula to do the following:

1. if line 1 = line 2 in column A, then "No." in column C, if not then
" ",

2. if line 1 = line 2 in column B, then "Date" in column D, if not
then " ",

3. if line 1 = line 2 in column C, then "Amount" in column E, if not
then " ",


4. if line 1 = line 2 in column A and if line 1 = line 2 in column B
and if line 1 = line 2 in column C, then "HIT" in column F, if not
then " "

Thanks for your effort.

Alvaro

 

[Don Guillett]

if I understand your need
in col c copied across to c and changed to suit text
=IF(A2=$A$1,"no","")
in col f
=IF(COUNTIF(A2:C2,$A$1)=3,"Hit","")

 

[Alvaro]

Thanks Don.

No, I do not think this will do.

What I want is to select from a numerical list of invoices from
vendors, those which have the same Number, same Date and same Amount
so that they are identified as Duplicates on the three conditions
tested, making them candidates for further scrutiny.

During the process I also want to identify those which meet any of the
conditions tested and report on that finding.

I hope the problem is a little bit better stated now.

Thanks again

Alvaro

 

[Guest]

in D:G (not C:F) onwards ...

=IF($A1=$A2,"No.","")

=IF($B1=$B2,"Date","")

=IF($C1=$C2,"Amount","")

=IF(AND(A1=A2,B1=B2,C1=C2),"Hit","")

 

[Alvaro]

Thanks a lot Toppers. It did work to my expectations.

Alvaro