IF OR Condition

[uswyne]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Status[/TD]
[TD]Date of joining[/TD]
[TD]Date of transfer[/TD]
[TD]Date of resign[/TD]
[TD]formula[/TD]
[/TR]
[TR]
[TD]Active[/TD]
[TD]1/1/18[/TD]
[TD][/TD]
[TD][/TD]
[TD]=IF(ISNUMBER([@[Date of Leaving]]),"Resigned","Active")[/TD]
[/TR]
[TR]
[TD]Resigned[/TD]
[TD]1/1/18[/TD]
[TD][/TD]
[TD]1/31/18[/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]=IF(ISNUMBER([@[Date of Leaving]]),"Resigned","Active")[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
[TR]
[TD]Transfer[/TD]
[TD]1/1/18[/TD]
[TD]1/15/18[/TD]
[TD][/TD]
[TD]Combined formula required [/TD]
[/TR]
</tbody>[/TABLE]

When date of Joining entered the status would be Active and when enter date of withdrawal status would be Resigned. But i could not find the way to manage transfer is same formula.

Kindly help

 

[arunsjain]

Hi Uswyne,

Date of Date of Date of
Joining transfer resign
Cell AI Cell AJ Cell AK


=IF(AND(AI16<>"",AJ16="",AK16=""),"Active",IF(AND(AI16<>"",AJ16<>"",AK16=""),"Transfer",IF(AK16<>"","Resigned","")))

Use above formula....

 

[uswyne]

Thanks for your help transfer is not being worked.

 

[uswyne]

correct formula is

=IF(AND(AI16<>"",AJ16="",AK16=""),"Active",IF(AND(AI16<>"",AJ16<>""),"Transfer",IF(AK16<>"","Resigned","")))

Thanks you very much

 

[arunsjain]

Just one query, if all three columns are filled then result will be "Transfer", Instead of "Resigned"

Like
Date of Joining 1/10/2010
Transfer date 15/10/2010
Resign date 1/11/2015

In that case result should be "Resigned" but with your formula will show "Transfer".