Nested If statement help please

[jancliff]

I have a list of numbers in column a and a list of dates in column b. If I just take column a and do this IF statement,
IF(A2=A1,"DUPLICATE ENTRY"," ") so it can identify whethere there are any duplicates in the list. I also want this IF statement

IF (B2-B1>90,"OVER 90 DAYS"," ")

I am trying to combine them both so I can first check to see if A2 =A1 and if it does then do the check if B2 - B1 >90 to display OVER 90 DAYS.



I am getting in a bit of a muddle....can anyone point me in the right direction..

Many thanks

 

[Murli]

Try this:

=IF(AND(A2=A1,(B2-B1)>90),"OVER 90 DAYS","")

 

[StevenS]

IF(A2=A1,IF(B2-B1>90,"OVER 90 DAYS","DUPLICATE ENTRY")," ")

if a2 = a1, it will check wether B2-B1>90, if so it will give "over 90 days", if not, it will give "duplicate entry"
if a2 <> a1, it will give " "

 

[jancliff]

The second one worked a treat many thanks..... That has really helped as I can now use the theory for so much more!

 

[Ian Mac]

The second option may work a treat but I'd take out the " " and use "".

You don't need a space in your result.