Three arguments from two Column in one formula

[Len Cun]

Please help.

This is the scenario:
Column A-refers to employment status(pro by/regular/separated)
Column B-refers to active(true/false)
Column C-i want to display here:
If A="proby" or "separated"; C must display "Rcvng only"; if A="regular" C must display "suspension" and if B="true" C must display "suspension"; B="false" C must display "rcvng only"

Is this possible?looking forward for your kind response...

Thanks in advance!
Len

 

[Len Cun]

Also, what will be the formula if i also want to add another condition that all dates occurring from january 2018 backwards will also be displayed as rcvng only?
Looking again for your kind responses. thanks!
[TABLE="width: 1015"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]code[/TD]
[TD]Emp No.[/TD]
[TD]Emp. Name[/TD]
[TD]Date Hired[/TD]
[TD]Employment Status[/TD]
[TD]Position - HRIS[/TD]
[TD]Position - Opns[/TD]
[TD]Current Location - Opns[/TD]
[TD]Active - Opns[/TD]
[TD]Date of Summary Encoding[/TD]
[TD]Type[/TD]
[TD]Nature of Offense[/TD]
[TD]Date Comitted[/TD]
[TD]No. Of Offense[/TD]
[TD]Penalty[/TD]
[/TR]
[TR]
[TD]Ca-000302[/TD]
[TD]MJ1004[/TD]
[TD]MONTERONA, RANDY GINO[/TD]
[TD]10/15/2010[/TD]
[TD]Regular[/TD]
[TD]DRIVER[/TD]
[TD]DRIVERS[/TD]
[TD]CALOOCAN[/TD]
[TD]TRUE[/TD]
[TD]12/01/2017[/TD]
[TD]Minor[/TD]
[TD]Not entering SM term[/TD]
[TD]05/29/2017[/TD]
[TD]2nd[/TD]
[TD]suspension[/TD]
[/TR]
[TR]
[TD]Ca-000303[/TD]
[TD]MJ1004[/TD]
[TD]MONTERONA, RANDY GINO[/TD]
[TD]10/15/2010[/TD]
[TD]Regular[/TD]
[TD]DRIVER[/TD]
[TD]DRIVERS[/TD]
[TD]CALOOCAN[/TD]
[TD]TRUE[/TD]
[TD]12/01/2017[/TD]
[TD]Minor[/TD]
[TD]Not entering SM term[/TD]
[TD]06/05/2017[/TD]
[TD]3rd[/TD]
[TD]suspension[/TD]
[/TR]
[TR]
[TD]Ca-000340[/TD]
[TD]OE1701[/TD]
[TD]OFIANGGA, CHRISTIAN FERDINAND DEL MUNDO[/TD]
[TD]05/29/2017[/TD]
[TD]Separated[/TD]
[TD]CONDUCTOR[/TD]
[TD]DISMISS[/TD]
[TD][/TD]
[TD]FALSE[/TD]
[TD]12/06/2017[/TD]
[TD]Grave[/TD]
[TD]IBO[/TD]
[TD]08/29/2017[/TD]
[TD]2nd[/TD]
[TD]Rcvng Only[/TD]
[/TR]
[TR]
[TD]Ca-000050[/TD]
[TD]AG1404[/TD]
[TD]APONGOL, REYNAN MANANSALA[/TD]
[TD]04/15/2016[/TD]
[TD]Regular[/TD]
[TD]CONDUCTOR[/TD]
[TD]CONDUCTORS[/TD]
[TD]CALOOCAN[/TD]
[TD]TRUE[/TD]
[TD]12/06/2017[/TD]
[TD]Grave[/TD]
[TD]IBO[/TD]
[TD]05/31/2017[/TD]
[TD]1st[/TD]
[TD]suspension[/TD]
[/TR]
[TR]
[TD]Ca-000052[/TD]
[TD]AG1404[/TD]
[TD]APONGOL, REYNAN MANANSALA[/TD]
[TD]04/15/2016[/TD]
[TD]Regular[/TD]
[TD]CONDUCTOR[/TD]
[TD]CONDUCTORS[/TD]
[TD]CALOOCAN[/TD]
[TD]TRUE[/TD]
[TD]12/06/2017[/TD]
[TD]Minor[/TD]
[TD]Unauthorized discounts[/TD]
[TD]06/22/2017[/TD]
[TD]2nd[/TD]
[TD]suspension[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joyner]

You are welcome

Will that condition be he first one to test?

Which date / what column?

Also - make sure you do not post real data - you may not have but just making sure

 

[Joyner]

Also, do you really want to have a hard coded date (January 2018) or do you really want something like:
If the date is 180 days less than today
Or, is the date less than January of the current year

 

[Joyner]

If you wanted something like a date 180 before today, youcould use something like this where column D has the date, change as needed:

=IF(D2<=TODAY()-180,"RcvngOnly",IF(AND(OR(A2={"proby","separated"}),B2=FALSE),"RcvngOnly",IF(AND(A2="Regular",B2=TRUE),"suspension","RcvngOnly")))

Based on what you have so far, I’m not sure you couldn’thave just:

=IF(D2<=TODAY()-180,"RcvngOnly",IF(AND(A2="Regular",B2=TRUE),"suspension","RcvngOnly"))

 

[Len Cun]

Also, do you really want to have a hard coded date (January 2018) or do you really want something like:
If the date is 180 days less than today
Or, is the date less than January of the current year

The column under prev. Served must be the first reference to test. Bec. If it has a value more than zero,it is considered active.

As for the date,actually,all summary date which are 6months old from must be marked as inactive..

Thanks again..