if statements and 3 conditions to find duplicates

[RichardO]

Hello all:

I hope you can help with the following.

In column AA I have the numbers 40 or 50 in the cells. In column AB
have dollar amounts. I sorted column AB in ascending order.

I would like to write an if statement such that if AA2=40 and AA3 =5
and both AB2 and AB3 are the same, I would like excel to give the wor
"dup" in AC2.

Without the first 2 conditions, the if statement would b
if(AB2=AB3,"dup","") but I don't know how to incorporate the first
conditions.

Thanks a lot for helping.

Richard

 

[Frank Kabel]

Hi
try:
if(AND(AB2=AB3,AA2=40,AA3=50),"dup","")