IF OR Condition

[uswyne]

Status	Date of joining	Date of transfer	Date of resign	formula
Active	1/1/18			=IF(ISNUMBER([@[Date of Leaving]]),"Resigned","Active")
Resigned	1/1/18		1/31/18	=IF(ISNUMBER([@[Date of Leaving]]),"Resigned","Active") <tbody> </tbody>
Transfer	1/1/18	1/15/18		Combined formula required

<tbody>
</tbody>

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".