Nested if statement ?

[Angelaf]

I want to identify all emp id's that have had an increment of more than one
point - something like:

Emp ID= previous Emp ID and point >previous point +1 ? Would this be a
nested if statement of some sort?


Emp ID Scale Point
00003 GD10 44
00003 GD10 44
00007 GD10 43
00007 GD10 44
00010 GD10 43
00010 GD10 44

 

[macropod]

Hi Angelaf,

For employee ID 003, it could be as simple as:
=C3-C2>1
This will return 'True' if the increment is greater than 1, 'False' otherwise.

Cheers

 

[Max]

Try in D2:
=IF(COUNTIF(A$2:A2,A2)=2,IF(C2-INDEX(C:C,MATCH(A2,A:A,0))>1,"x",""),"")
Copy down. Col D will flag it as "x" as specified, ie where:

Emp ID = previous Emp ID and point > previous point +1 ?

Note that in your posted data, no line qualifies. Perhaps you meant ">=",
not ">" ? If so, just change the ">1" part in the expression to ">=1"

 

[Gaurav]

What do you want the formula to return?
Where is previous point?